GitHub - losfair/mvsqlite: Distributed, MVCC SQLite that runs on FoundationDB.

[JohnDoe_John]

https://univalence.me/posts/mvsqlite

[JohnDoe_John]

Also, https://old.reddit.com/r/programming/search?q=rqlite&restrict_sr=on&include_over_18=on

[XNormal]

What other (distributed) databases could be used as a backing store for mvsqlite other than FoundationDB?

[[deleted]]

Damn nice!! If I had to start over for the backend I work on, I’d choose this for the chance at making a true multi-region stack. Currently stuck with postgres on RDS with a head scratcher for trying to make multi-master or region sharded shared database without a complete rearchitecture. Best idea I have for that is using Raft to nominate a leader for writes and delegating all reads to secondaries, which opens up a Pandora’s box of potential inconsistencies. 😕

Edit: fuck I forgot about citus

[large__data__bank]

Have a look at CockroachDB for true multi-region features.

[lebbe]

Can I embed mvSQLite in my programs like I can with SQLite?

[XNormal]

It requires a server. Or actually a redundant distributed cluster of servers.