How SQLite Is Tested

Over a decade ago, the maintainer of SQLite gave a talk at OSCON about their testing practices. One concept that stood out to me was the power of checklists, the same tool pilots rely on before every flight. He also mentioned Doctors Without Borders, who weren't seeing the outcomes they expected when it came to saving lives. One surprising reason? The medical teams often didn't speak the same language or even know each other's names. The solution was simple: a…

The section on static analysis is somewhat damning: Static analysis has not proven to be especially helpful in finding bugs in SQLite. Static analysis has found a few bugs in SQLite, but those are the exceptions. More bugs have been introduced into SQLite while trying to get it to compile without warnings than have been found by static analysis.

One of my proudest moments was finding a bug in SQLite where a corrupted index caused a select statement to segfault Firefox. I jumped through a lot of hoops to get to the point where I got a backtrace that showed me the SQL statement of a corrupted places.sqlite. I then loaded SQLite on the data file, ran the statement and reproduced the segfault. One of their lead devs then got in contact with me, grabbed the data file and…

In SQlite's source code, it has the following comment. 2001 September 15 The author disclaims copyright to this source code. In place of a legal notice, here is a blessing: - May you do good and not evil. - May you find forgiveness for yourself and forgive others. - May you share freely, never taking more than you give. SQLite is _the_ most amazing database in my opinion. (Not the most amazing distributed database for obvious reasons). It strips away…