Hacker News new | ask | show | jobs
by jitl 970 days ago
To me it seems like the options for user-defined schema are either push-down the schema (and do one schema per spreadsheet) which lets you take full advantage of your DB's query planner statistics system etc, do an entity-attribute-value table and deal with building your own query planner and collecting your own statistics, or go with a document store and build some kinds of dynamic indexes instead of dynamic table schemas.