3 ms·
Frankly whenever people show me some "new SQL killer" it often looks like "SQL with extra steps". Sure, everyone is afraid of joins, but you can often engineer
by petterroea 11mo ago
Frankly whenever people show me some "new SQL killer" it often looks like "SQL with extra steps". Sure, everyone is afraid of joins, but you can often engineer yourself further away from that. Document-oriented database systems are fine, but have downsides.
One of the main reasons I won't be dropping SQL unless I have to is schema. I *love* that data stored in SQL has an inherent schema. As anyone who has dealt with raw JSON will know, it can get pretty ugly when you make changes and either have to migrate everything, or complicate your parsing logic to handle corner cases. As long as I have a sane SQL schema, I can use migrations to make sure all data is in line with a single schema, and that makes reasoning and writing business logic easier. I have worked places where they haven't been as strict about schema as they probably should have been with DDB's and its ugly.
I like when my code is stupid simple because I am dumb and make tonnes of dumb mistakes. Having a database with a strict schema means it is simple to reason about. DDB may seem easy because you can just slap objects in a database, but you are actually just moving the complexity and schema job to YOU the developer. We all make stupid mistakes from time to time, so best to pick tools that makes our job easy, right?
I'm happy to replace SQL but I haven't found anything that gives me the qualities I want yet.