Twelve years of distributed SQLite

Re:Twelve years of distributed SQLite by tra3 on Saturday October 24, 2026 @12:33AM (#50218382)

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.

[ Parent | on HN ]

Re:Twelve years of distributed SQLite by bendangelo on Saturday October 24, 2026 @01:55AM (#50218661)

Can use one sqlite per tenant or look into the new multi writer lib on github.

[ Parent | on HN ]

Re:Twelve years of distributed SQLite by ImJasonH on Saturday October 24, 2026 @06:58AM (#50220084)

This one? https://github.com/sqliteai/sqlite-multiwriter

[ Parent | on HN ]

Re:Twelve years of distributed SQLite by npn on Saturday October 24, 2026 @12:40AM (#50218399)

Wal or wal2 can help you with that.

[ Parent | on HN ]

Re:Twelve years of distributed SQLite by nchmy on Saturday October 24, 2026 @08:55AM (#50220816)

Because sqlite is extremely fast. Most projects won't hit its limits

[ Parent | on HN ]

Re:Twelve years of distributed SQLite by rapind on Saturday October 24, 2026 @05:16PM (#50225401)

I'm using it w/ a Rust server and I can get up to 80k writes per second, 200k reads per second. You won't get that with other databases without paying a lot and doing a lot of special architecture.

[ Parent | on HN ]

Re:Twelve years of distributed SQLite by tra3 on Saturday October 24, 2026 @05:41PM (#50225648)

That sounds like a lot. Is the rust process serving parallel requests?

[ Parent | on HN ]

Re:Twelve years of distributed SQLite by rapind on Saturday October 24, 2026 @06:01PM (#50225808)

Rechecked my benchmarks. 193,000 writes per second (rust), each write holds the lock for about 5 µs.

Full report here: https://github.com/pairshaped/gleam_sqlite_benchmarks/blob/m...

Obviously real world queries will vary, but I tried to be representative of the type of queries / updates I am sending.

[ Parent | on HN ]