HUNTING A 16-YEAR-OLD SQLITE BUG WITH TLA+: IS DQLITE AFFECTED?
SQLite recently addressed a long-standing bug related to the Write Ahead Log (WAL) that could cause database corruption, present in the system for 16 years. The dqlite team investigated whether this bug affects their implementation by modeling SQLite's behavior in TLA+ and comparing it with how dqlite interacts with SQLite and concluded that dqlite is not affected due to its stricter locking mechanisms that prevent simultaneous writes and checkpoints.