The Definitive Guide to SQLite (Second Edition)

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. Annotation Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite--an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite's capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it! 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 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 features such as the shared cache, the SQL Logic Test Suite, the Unlock and Notify APIs, and query plan improvements. Who this book is for The Definitive Guide to SQLite  is for developers needing a zero-maintenance database solution to deploy as an embedded component within their product. The book is especially useful for mobile developers delivering applications to run on the iPhone, or on the Android platform. PHP developers will also find the book useful if they are using the default database delivered as part of a PHP installation. Table of Contents 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 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