© 2010

The Definitive Guide to SQLite

  • Authors


  • 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.


Table of contents

  1. Front Matter
    Pages i-xix
  2. Grant Allen, Mike Owens
    Pages 1-16
  3. Grant Allen, Mike Owens
    Pages 17-46
  4. Grant Allen, Mike Owens
    Pages 47-86
  5. Grant Allen, Mike Owens
    Pages 87-124
  6. Grant Allen, Mike Owens
    Pages 125-152
  7. Grant Allen, Mike Owens
    Pages 153-193
  8. Grant Allen, Mike Owens
    Pages 195-217
  9. Grant Allen, Mike Owens
    Pages 219-252
  10. Grant Allen, Mike Owens
    Pages 253-277
  11. Grant Allen, Mike Owens
    Pages 279-301
  12. Grant Allen, Mike Owens
    Pages 303-322
  13. Back Matter
    Pages 323-347

About this book


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!


SQL SQLite database database management relational database

About the authors

Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.

Bibliographic information

Industry Sectors
Chemical Manufacturing
IT & Software
Consumer Packaged Goods
Materials & Steel
Finance, Business & Banking
Energy, Utilities & Environment