Grant Allen, Owens Mike. The Definitive Guide to SQLite

2nd edition. — Apress, 2010. — 368 p.The Definitive Guide to SQLite, Second Edition is your one-stop resource for integrating one of the most advanced and innovative open source database management systems into your development projects. SQLite is freely-available and comes with an amazingly small foot print of less than 300 kilobytes for a full-blown implementation. It’s perfect for mobile and other embedded implementations, including the iPhone and Android platforms. It’s also the default database distributed with PHP. In The Definitive Guide, Authors Grant Allen and Mike Owen provide complete coverage of SQLite’s powerful array of features. You’ll learn to use SQLite with PHP, C++, Java, and more. You’ll see how SQLite’s file-based approach can easily handle databases as large as two terabytes.Introducing SQLite.
Getting Started
SQL for SQLite
Advanced SQL for SQLite.
SQLite Design and Concepts.
The Core C API
The Extension C API.
Language Extensions
iOS Development with SQLite
Android Development with SQLite
SQLite Internals and New Features