Hunting a 16-year-old SQLite bug with TLA+ is dqlite affected?
Summary
The article explains SQLite's WAL checkpointing bug and how the dqlite team used TLA+ to model and test whether their implementation could be affected. It outlines the bug's anatomy, reproduction, and fixes, compares how SQLite and dqlite handle checkpoints, and concludes that dqlite is not affected due to locking strategies, with notes on SQLite's 2026 fix.