2 ms·
NoSQL databases have as many schemas as there have been changes to the model. Everytime you make a change, and are keeping old data, you have another schema.
by wvenable 11y ago
NoSQL databases have as many schemas as there have been changes to the model. Everytime you make a change, and are keeping old data, you have another schema. Your code then has to be aware of every schema that has ever existed. Over time this becomes more and more painful and error-prone.
In a relational database, you have one schema and you have to convert/update your data to match that schema whenever it changes.
I've done one big project many years ago that used NoSQL storage of heterogeneous "document" types -- a perfectly reasonable use-case for the technology -- and I wouldn't do it again. Although at the time it seemed crazy to create different tables to hold this data it would have made that code so much simpler now.
- gjolund 11y agoImagine handling data like that with javascript. Mutable data types, with mutable data, and inconsistent error handling. Burned me out in a matter of months.