I have never examined this in any detail before. It looks far easier than the mass majority of clustered database architectures.

https://rqlite.io/

I know that latest rails suggests SQLite as one of the production options. I don’t get how it’d work with concurrent access though. Time to look into it.

Very timely for me. I run dqlite in a small cluster and I'm looking to move off it to something more robust. What's recommended in this regime?

There is also hctree from sqlite.

Like the idea of distributed SQLite, but do we have benchmark? What use cases it has advantage?