My thoughts on Lessons from using SQLite in production: Lessons from using SQLite in production

Commentary

  • Lessons from using SQLite in production
  • Useful bit here. The WAL mode is absolutely a clutch, most people don’t know of, and just lament about it being a single-writer constrained DB. It’s a super-powerful and very versatile lightweight database.
  • Folks at Turso are making it even better with read-write replicas and syncing, having a daemon for SQLite. The future might be apps full of SQLite.