This article in Guardian Unlimited provides a good introduction to SQLite and the story behind it.
Since SQLite is the database used by cool stuff like Google Gears, Apple’s Core Data, and (cough) ProjectPipe, it’s great to see it get positive coverage in a mainstream news outlet.
The article is also a veritable infomercial for automated testing:
Hipp attributes much of the reliability of SQLite to his use of tests. Less than half of the program code is delivered as the database engine. The larger part consists of thousands of automated tests, which exercise the code and check that the results are as expected. “That’s the real key to keeping it working well,” he says.
One of the goals for SQLite was to keep the database library very
small (under 250KB). If Dr. Hipp et al. hadn’t spent all that time
writing automated tests, I’m sure that SQLite would also have a very
small user base as well 
