The Definitive Guide to SQLite, 2/e (Paperback)

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.  

• Demonstrates SQLite’s use in iPhone and Android development.
• Helps you integrate with popular languages such as PHP, C++, Java, and more.
• Serves as an excellent tutorial, and ongoing reference.

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.

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.

《SQLite 完全指南，第二版》是您整合最先進和創新的開源資料庫管理系統之一的一站式資源。SQLite 是免費提供的，並且具有驚人的小尺寸，完整實現的大小不到 300 KB。它非常適合移動和其他嵌入式實現，包括 iPhone 和 Android 平台。它也是 PHP 預設的資料庫。在《SQLite 完全指南，第二版》中，作者 Grant Allen 和 Mike Owen 提供了對 SQLite 強大功能的全面介紹。您將學習如何使用 SQLite 與 PHP、C++、Java 等語言。您將了解到 SQLite 的基於文件的方法如何輕鬆處理高達兩 TB 的資料庫。您還將全面了解 API，並學習如何在 iPhone 和 Android 平台上將 SQLite 嵌入到移動應用程式中。

本書演示了 SQLite 在 iPhone 和 Android 開發中的使用。它幫助您與流行的語言（如 PHP、C++、Java 等）進行整合。它是一本優秀的教程和持續參考資料。

您將學到以下內容：
- 將 SQLite 部署為 iPhone 和 Android 應用程式的資料庫引擎。
- 從 Java、C++、PHP 和其他關鍵語言與 SQLite 進行互動。
- 創建強大的資料庫設計，充分利用主鍵和外鍵約束的新支援。
- 直接將零維護資料庫嵌入到您編寫的應用程式中。
- 通過深入了解 SQLite 內部來提高性能。
- 利用新功能，如共享快取、SQL 邏輯測試套件、解鎖和通知 API，以及查詢計劃的改進。

本書適合以下讀者：
《SQLite 完全指南》適用於需要零維護資料庫解決方案並將其部署為產品內嵌組件的開發人員。對於提供運行於 iPhone 或 Android 平台的應用程式的移動開發人員來說，本書尤其有用。如果您正在使用作為 PHP 安裝的一部分提供的預設資料庫，PHP 開發人員也會發現本書很有用。