The Definitive Guide to SQLite (Repost)

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 to SQLite, Second Edition, 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. You’ll also enjoy complete coverage of the API, and learn to embed SQLite within mobile applications on the iPhone, and on Android platforms.

What you’ll learn
Deploy SQLite as the database engine for iPhone and Android applications.
Interact with SQLite from Java, C++, PHP, and other key languages.
Create robust database designs, taking advantage of new support for primary and foreign key constraints.
Embed zero-maintenance databases directly within applications that you write.
Improve performance through a good understanding of SQLite internals.
Exploit new features such as the shared cache, the SQL Logic Test Suite, the Unlock and Notify APIs, and query plan improvements.