Ebook: The Definitive Guide to SQLite

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management.

The Definitive Guide to SQLite is the first book to devote complete coverage to this powerful database. It offers you a thorough overview of SQLite capabilities and APIs, while remaining cognizant of newcomers who may be making their first foray into a database environment with SQLite. This book serves as both a first-time tutorial and future reference guide.

---

These days, applications are expected to efficiently manage an ever growing range of data. Yet it is rarely practical to embed a traditional relational database such as Oracle or MySQL within an application, due to not only size constraints but also because of the additional administrative overhead these databases require. While embeddable databases are small enough to ensure little additional total increase in application size, they often have little to offer by way of capabilities and power. So what's a developer to do?

For many, the answer is SQLite (http://www.sqlite.org/), an open source embeddable database with an amazingly small footprint (less than 250 Kb) but packing a powerful array of features.

The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. Offering experienced database developers a thorough overview of its capabilities and APIs, yet cognizant of newcomers who may be making their first foray into the database environment with SQLite, this book acts as both an ideal tutorial and reference guide.

---

These days, applications are expected to efficiently manage an ever growing range of data. Yet it is rarely practical to embed a traditional relational database such as Oracle or MySQL within an application, due to not only size constraints but also because of the additional administrative overhead these databases require. While embeddable databases are small enough to ensure little additional total increase in application size, they often have little to offer by way of capabilities and power. So what's a developer to do?

For many, the answer is SQLite (http://www.sqlite.org/), an open source embeddable database with an amazingly small footprint (less than 250 Kb) but packing a powerful array of features.

The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. Offering experienced database developers a thorough overview of its capabilities and APIs, yet cognizant of newcomers who may be making their first foray into the database environment with SQLite, this book acts as both an ideal tutorial and reference guide.

Content:
Front Matter....Pages i-xxi
Introducing SQLite....Pages 1-16
Getting Started....Pages 17-45
The Relational Model....Pages 47-72
SQL....Pages 73-170
Design and Concepts....Pages 171-203
The Core C API....Pages 205-253
The Extension C API....Pages 255-299
Language Extensions....Pages 301-340
SQLite Internals....Pages 341-362
Back Matter....Pages 363-440

---

These days, applications are expected to efficiently manage an ever growing range of data. Yet it is rarely practical to embed a traditional relational database such as Oracle or MySQL within an application, due to not only size constraints but also because of the additional administrative overhead these databases require. While embeddable databases are small enough to ensure little additional total increase in application size, they often have little to offer by way of capabilities and power. So what's a developer to do?

For many, the answer is SQLite (http://www.sqlite.org/), an open source embeddable database with an amazingly small footprint (less than 250 Kb) but packing a powerful array of features.

The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. Offering experienced database developers a thorough overview of its capabilities and APIs, yet cognizant of newcomers who may be making their first foray into the database environment with SQLite, this book acts as both an ideal tutorial and reference guide.

Content:
Front Matter....Pages i-xxi
Introducing SQLite....Pages 1-16
Getting Started....Pages 17-45
The Relational Model....Pages 47-72
SQL....Pages 73-170
Design and Concepts....Pages 171-203
The Core C API....Pages 205-253
The Extension C API....Pages 255-299
Language Extensions....Pages 301-340
SQLite Internals....Pages 341-362
Back Matter....Pages 363-440
....