4 ms·
SQL is a bad solution to the wrong problem. After 50 years it remains non-intuitive and confusing and extracts a tax penalty far greater than its value add. Wo
by dnomad 8y ago
SQL is a bad solution to the wrong problem.
After 50 years it remains non-intuitive and confusing and extracts a tax penalty far greater than its value add. Worse, the problem it claims to solve, "I have all my data in one database now let me transact over it", isn't viable and was never actually viable at scale.
Unfortunately this proposal doesn't understand the real problems with SQL (lack of types, lack of distribution, and no separation between the data write model and the data read model). It actually doesn't seem to introduce anything really new that can't be done using CEP Engines already.
- jwdunne 8y agoDo you have any recommendations on where to read about the problems of SQL? When you put it this way, clearly my assertion that "SQL isn't bad" needs a review.
- techno_modus 8y agoThere have been many critiques of SQL for example: https://sigmodrecord.org/publications/sigmodRecord/1306/pdfs/11.reports.atzeni.pdf https://sigmodrecord.org/publications/sigmodRecord/1306/pdfs...
- jwdunne 8y agoThanks for this :) I ask for recommendations because I don't know what I don't know. I've read a few criticisms of SQL where some conclude "just use mongodb". A good recommendation from an expert helps avoid faulty understanding.
- gaius 8y agoisn't viable and was never actually viable at scale. And yet the entire global economy somehow works. Maybe viable and scale don’t mean what you think they mean... I mean I run relational databases of 10s of Tb and know people doing 100s. And people with mere Gb tell me they’re doing amazing things with scalability.... lol