The Definitive Guide to SQLite (Second Edition)

✍ Scribed by Grant Allen, Mike Owens

• Publisher: Apress
• Year: 2010
• Tongue: English
• Leaves: 369
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Prelim......Page 1
Contents at a Glance......Page 6
Contents......Page 7
About the Authors......Page 18
About the Technical Reviewer......Page 19
Acknowledgments......Page 20
Introduction......Page 21
Introducing SQLite......Page 23
Getting Started......Page 39
SQL for SQLite......Page 69
Advanced SQL for SQLite......Page 109
SQLite Design and Concepts......Page 147
The Core C API......Page 175
The Extension C API......Page 217
Language Extensions......Page 241
iOS Development with SQLite......Page 275
Android Development with SQLite......Page 301
SQLite Internals and New Features......Page 325
Index......Page 345