Twelve years of distributed SQLite
Web page · https://philipotoole.com/twelve-years-of-distributed-sqlite
First seen by Oriel on .
AI summary
Philip O'Toole traces distributed SQLite from rqlite's 2014 launch, arguing that replication around SQLite has persisted because different approaches serve distinct consistency and recovery needs.
- rqlite put a Raft log in front of SQLite; its CP design requires leader writes and majority acknowledgement, and rejects writes from a partitioned minority.
- The article distinguishes consensus systems such as rqlite and dqlite, WAL streaming for single-node recovery with Litestream, and CRDT-based merging with cr-sqlite.
- dqlite is an embedded library built for Canonical products, while rqlite is a standalone server; Litestream targets inexpensive disaster recovery rather than clustered availability.
- Later projects including LiteFS, libSQL, SQLite Cloud, and Cloudflare D1 brought replicated SQLite to platforms and hosted services.
- The author notes that open-source projects established the idea years before commercial services attracted funding or acquisitions.
#sqlite #distributed systems #raft #crdts
Generated by gpt-5.6-sol. Check the original for details.
Metric trends
Last 30 days · Up to 120 recorded samples per source and metric, with reposts kept separate · First and latest retained
Points
Score reported by the source.
- Hacker News: 382, latest observation ; +373 over observed period since
- Lobsters: 20, latest observation ; +19 over observed period since
Comments
Comment count reported by the source.
- Hacker News: 66, latest observation ; +66 over observed period since
- Lobsters: 1, latest observation ; +1 over observed period since
Aliases
| Source | External ID | URL |
|---|---|---|
| Hacker News | 50217500 | https://philipotoole.com/twelve-years-of-distributed-sqlite/ Read discussion |
| Lobsters | rqefcw | https://philipotoole.com/twelve-years-of-distributed-sqlite/ Read discussion |