The Definitive Guide to SQLite, 2nd Edition

Book Description

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

1. Introducing SQLite
2. Getting Started
3. SQL for SQLite
4. Advanced SQL for SQLite
5. SQLite Design and Concepts
6. The Core C API
7. The Extension C API
8. Language Extensions
9. iOS Development with SQLite
10. Android Development with SQLite
11. SQLite Internals and New Features

中文：

书名：The Definitive Guide to SQLite, 2nd Edition

在企业计算的世界之外，有一种数据库使大量的软件和硬件能够灵活地使用关系数据库功能，而不需要传统数据库管理系统的包袱和成本。该数据库就是SQLite–一个可嵌入的数据库，占用的空间小得惊人，但却能够处理巨大的数据库。SQLite配备了一系列强大的功能，可通过多种编程和开发环境使用。C、Java、Perl、PHP、Python、Ruby、TCL等语言都支持它。

SQLite权威指南，第二版 致力于全面报道这个功能强大的数据库的最新版本。它全面概述了SQLite的功能和API。该书还使用SQLite作为帮助新手首次涉足数据库开发的基础。在很短的时间内，您可以编写各种各样的程序，如服务器端浏览器插件或下一个伟大的iPhone或Android应用程序！

• 了解针对C、Java、Perl、PHP、Python、Ruby和TCL的SQLite扩展。
• 深入了解SQLite的内部结构。
• 探索使用SQLite开发iOS(IPhone)和Android应用程序。

从手机和GPS设备到机顶盒和网络浏览器，SQLite是全球数千种产品选择的解决方案。几乎可以肯定的是，您每天都在使用SQLite，甚至没有意识到这一点！

你会学到什么

• 将SQLite部署为iPhone和Android应用程序的数据库引擎。
• 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.
• 将零维护数据库直接嵌入到您编写的应用程序中。
• 通过对SQLite内部结构的深入了解来提高性能。
• 利用共享缓存、SQL Logic测试套件、解锁和通知API以及查询计划改进等功能。

这本书是为谁而写的

SQLite的权威指南它面向需要零维护数据库解决方案的开发人员，以作为其产品中的嵌入式组件进行部署。这本书对于开发在iPhone或Android平台上运行的应用程序的移动开发人员特别有用。如果使用的是作为PHP安装的一部分提供的默认数据库，那么PHP开发人员也会发现这本书很有用。

Table of Contents

1. Introducing SQLite
2. Getting Started
3. SQL for SQLite
4. 用于SQLite的高级SQL
5. SQLite设计和概念
6. The Core C API
7. The Extension C API
8. Language Extensions
9. 使用SQLite进行iOS开发
10. 使用SQLite进行Android开发
11. SQLite内部结构和新功能