Re:Move Fast and Migrate Things: How We Automated Migrations...
by Scarbutt on Wednesday February 06, 2019 @07:04PM
(#19101572)
You say NoSQL document but have you work with graph databases like neo4j that allow for flexible schemas? I think they mostly solve this problem but don't have the uptake of RDBMs because of matureness.
[ Parent
| on HN ]
Re:Move Fast and Migrate Things: How We Automated Migrations...
by Daishiman on Thursday February 07, 2019 @02:54AM
(#19103740)
The problem is that without a table lock of some sort you cannot guarantee that all the documents in a store satisfy the schema definition.
The NoSQL solution is basically say, "assume that nothing could ever possibly respect any semblance of a schema and build special cases around everything". It is a very unproductive way of thinking, taking defensive programming to the extreme.
Also, joins will be a necessity for all sorts of data querying. At the end of the day, schemas are a necessity for 98% of all work, whether defined through types or ad-hoc.