We used Quint to find over 10 bugs in SQLite while hardening Turso
a day ago
- #Formal Methods
- #SQLite Bugs
- #Software Testing
- Turso's commitment to rigorous testing is highlighted, with an emphasis on SQLite's high reliability standards, influencing user preference.
- Pavan Nambi utilized Quint, a formal method tool, to model the SQLite C API, uncovering more than 10 bugs in SQLite through generated traces.
- The testing process involved model checking in Quint, translating traces into C programs, and executing them against SQLite to validate the model.
- An example bug found: sqlite3_deserialize() crashed instead of returning SQLITE_BUSY when a read transaction was active, fixed by SQLite in a commit.
- Formal methods like Quint provided deeper exploration of specifications, enhancing Turso's testing and contributing to SQLite's bug fixes.