SQLite is a database engine that is embedded in a number of other application. For example, Mozilla uses SQLite to manage cookies. Being embedded, its important to have a small footprint and be very performant and resilient.

The testing practices for SQLite are very thorough, covering many types of testing in the automated suite. There are 91493 KLOC of test code in total.  The distribution package is built from 89.9 KLOC of C code.  That is 1017 lines of test code for every line of production code.

Inspired by the No Such Thing as a Fish podcast, I’ll be sharing several interesting (to me) testing related facts in this space.