3 ms·
Many of those choices to make it easier only work if you're willing to disallow a lot of SQL semantics. Like, tradeoffs in consistency? No transactions? That r
by angelbob 11y ago
Many of those choices to make it easier only work if you're willing to disallow a lot of SQL semantics.
Like, tradeoffs in consistency? No transactions? That requires not implementing some important bits of SQL.
- wobbleblob 11y agoYou're not forced to use joins and most DBs don't force you to use transactions if you don't need them. Sharding is supported by postgres, oracle, sqlserver and mysql, even if it's not the recommended solution in all cases. A database doesn't magically start to scale by not supporting SQL nor does SQL support magically prevent it from scaling.
- jeffdavis 11y agoInterestly, those tradeoffs have nothing to do with relational or non-relational. They are a part of SQL.