Post #2445505
2023-09-22 14:05 UTC
@chanakya@social.screamingatmyscreen.com As for its current dominance.
The relational model was an out-of-this-world invention. It rightfully took everything by storm. That's why it dominates today, there has been nothing better _as a product_ around. Models? Meh, maybe. Docs + key/value are too simple, graphs too hard.
So as long as nothing new challenges SQL, it's a nice middle ground that keeps incrementally being improved. With an immense ecosystem, from tools to uni courses, of course it's not going anywhere.
Replies (1)
-
@chanakya@social.screamingatmyscreen.com 2023-09-22 14:30
@chrisg@fosstodon.org The reason for SQL's ubiquity has to do with the strengths of its foundations - built on top of relational algebra. Every attempt to get rid of SQL has fallen flat. GraphQL crows that "SQL is for wimps", and when traversing large data sets it croaks. Malloy claims to to solve all of SQL's ills. I'm waiting. If anything, SQL is here to stay for good, and is growing in usage.