Document the scope of applications for which Tables are suited

brucehoff commented 6 years ago

Tables are designed for a certain class of applications. For example they are meant for bulk upload of large numbers of rows. On the other other hand, they do not form a relational database (RDB), lacking uniqueness constraints (primary keys), referential integrity (foreign keys), the ability to execute joins, etc. They are not meant for frequent. small transactions. We should explain what sorts of applications they are meant for, what they are not meant for, how to use them in cases in which the approach is not obvious. In addition there are these constraints:

tables cannot exceed 5GB
tables cannot exceed 120 columns
there is a maximum string length
there is a maximum size for large text / blobs
queries are 'eventually consistent' with the data uploaded to the table

kdaily commented 5 years ago

Hi @brucehoff @john-hill any update on this? @kimyen and I are triaging issues in the docs page. Thanks!

brucehoff commented 5 years ago

I would defer to @john-hill .

Sage-Bionetworks / synapseDocs

Document the scope of applications for which Tables are suited #384