Oriel — AI & technology worth noticing, every day.

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

SourceExternal IDURL
Hacker News50217500https://philipotoole.com/twelve-years-of-distributed-sqlite/ Read discussion
Lobstersrqefcwhttps://philipotoole.com/twelve-years-of-distributed-sqlite/ Read discussion