Remix.run Logo
▲ Twelve years of distributed SQLite(philipotoole.com)
84 points by otoolep 4 hours ago | 8 comments
▲tra3 27 minutes ago | parent | next [-]

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.

▲npn 20 minutes ago | parent [-]

Wal or wal2 can help you with that.

▲chasil an hour ago | parent | prev | next [-]

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

https://rqlite.io/

▲a3nz3g an hour ago | parent | prev | next [-]

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

▲feverzsj 34 minutes ago | parent | prev | next [-]

There is also hctree from sqlite.

▲esafak 2 hours ago | parent | prev [-]

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?

▲oblio an hour ago | parent [-]

What kind of issues did you run into?

▲esafak an hour ago | parent [-]

Loads of '500 database locked' errors. https://github.com/canonical/dqlite/issues/908