3 ms·
I’m really confused how you use SQL as your query language if you are also schema-less.
by klysm 4y ago
I’m really confused how you use SQL as your query language if you are also schema-less.
- tabtab 4y agoIt probably depends on how you define "schema-less". I can't speak for all brands, but in Dynamic Relational, a draft RDBMS idea, if you issue "SELECT madeUpColumn FROM myTable", you'd get nulls for that column (assuming myTable has rows). Depending on settings, the table could also be made up (unused), in which case you'd get zero rows back. You'd never get errors like "column doesn't exist" or "table does not exist" (unless you add constraints, which would be common as projects mature to ensure data integrity). You can only see if there is non-null data in a named slot. In such a case, there is no formal centralized schema. Any notion of schema would come from a survey of what data exists. Columns and tables are essentially "create on write" (UPDATE and INSERT).
- mjjp 4y agoWhy not? See for example N1QL used by Couchbase (a NoSQL database). Couchbase doesn't seem to get a lot of positive feedback but I kind of like it. Flexibility of a NoSQL database combined with a powerful SQL like query language.