News for hackers. Stuff that matters.
Re:Scaling Databases at Activision [pdf] by foota on Friday April 21, 2023 @11:13PM (#35663031)
I think describing newsql databases as "just" hidden sharing is underselling them substantial. The hard part is in the details of distributed transactions and consistency, among other things.
Re:Scaling Databases at Activision [pdf] by kevincox on Saturday April 22, 2023 @06:44AM (#35665159)
Yup. Consistency is by far the biggest advantage. Sharding isn't incredibly hard but it makes every query think about it for consistency purposes. Often you have a natural sharding key and it isn't much of a concern at all (example isolated user accounts) but at some point you need to go cross-shard and it gets very complicated (or you give up consistency and you get complicated bugs).

In theory a distributed SQL database can be a huge developer win because of this. Of course there are usually other tradeoffs to consider as well.