This is the first book to devote complete coverage to the most recent release of the popular embedded open source database SQLite. The book acts as both an ideal tutorial and reference guide. It offers experienced database developers a thorough overview of its capabilities and APIs, yet is mindful of newcomers who may be making their first foray into the database environment with SQLite. Significant material is devoted to SQLite internals, helping readers understand how to take full advantage of its features while minimally impacting resource consumption. SQLite has seen a rash of press coverage due to its increasing use within numerous high-profile projects such as Apple's Safari, and forthcoming versions of the Mozilla Project's Firefox browser, and Thunderbird mail client.