News for hackers. Stuff that matters.
Re:Sqlite 3.30.0 by minxomat on Friday October 04, 2019 @11:56PM (#21163711)
Hardly, that is more of a hack. There is however a distributed, clustered version of sqlite: Bloomberg's Comdb2. It has the same scaling factors as e.g. percona, can be Geo-replicated (multi-roomed) and has many advanced timing and financial data types. Plus SQL functions can be written in Lua. Oh, and it has super granular serialization guarantees, up to and including full linearizibility.

By using Sqlite as the SQL frontend, it retains features other NewSQL engines struggle with (recursive CTE, deep optimization, compatibility with existing queries etc)

Re:Sqlite 3.30.0 by e12e on Saturday October 05, 2019 @06:55AM (#21164852)
Wow, thats: https://github.com/bloomberg/comdb2

Looks interesting. Any experience using it in real projects?

Re:Sqlite 3.30.0 by minxomat on Saturday October 05, 2019 @07:02AM (#21164876)
Yeah it works well. I also sometimes push code into the db for faster execution (sorry on mobile, can't detail now).

Haven't tested out Geo replication though, but it's pretty straightforward. Clock drift maximum and all that.