News for hackers. Stuff that matters.
Re:The Rise of SQL-Based Data Modeling by jimbokun on Thursday January 30, 2020 @10:21AM (#22191901)
The nugget of truth was that joins and transactions are very difficult to implement in a performant manner in large scale, distributed systems. So it was possible to write very highly scalable databases if you give up on "SQL", which was a stand in for joins and transactions.

Since then, developers have been coming up with clever ways to implement distributed joins and transactions more efficiently and scalably on top of distributed database engines, and thus "the return of SQL".

Re:The Rise of SQL-Based Data Modeling by 6gvONxR4sf7o on Thursday January 30, 2020 @11:12AM (#22192451)
Where can I learn more about these clever developments?
Re:The Rise of SQL-Based Data Modeling by jimbokun on Thursday January 30, 2020 @11:54AM (#22192870)
I find CockroachDB one of the most interesting systems adding distributed transactions, joins and SQL support on top of a highly scalable key value store engine:

https://www.cockroachlabs.com/docs/stable/architecture/overv...

Re:The Rise of SQL-Based Data Modeling by jwatte on Thursday January 30, 2020 @12:48PM (#22193440)