The Definitive Guide to SQLite
SQLite is the database for minimalists: it requires no back-end daemons, and as such, does not follow the client-server architecture of the other popular RDMS's. Instead, SQLite is based on flat files and can access data with either the SQLite shell or through its several language extensions.
The Definitive Guide to SQLite is the perfect book about SQLite. It covers everything needed to start working with SQLite including installation, using the SQLite shell, and programming with SQLite using six different language extensions. Another feature of this book is the impressive discussion on basic SQL and SQL theory. I'm glad this was included with the book as it gives more depth to the SQLite topics. For example, when the reader learns about database locks and how SQLite's locks are based on the filesystem, they gain more of an understanding of what's happening to the actual database file instead of just blindly believing in some SQL theory.
With System Administration, I always try to be as much of a minimalist as I can. Doing so helps keep everything quiet and simple and eliminates several unnecessary problems. When possible, using SQLite instead of a full RDBMS can only strengthen this methodology -- and The Definitive Guide to SQLite is a great resource to learn SQLite from. I give it a 10/10.
