Synopses & Reviews
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 the latest version of 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.
Synopsis
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 the latest version of 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.
Synopsis
When I first began coding SQLite in the spring of 2000, I never imagined that it would be so enthusiastically received by the programming community. Today, there are millions and millions of copies of SQLite running unnoticed inside computers and gadgets made by hundreds of companies from around the world. You have probably used SQLite before without realizing it. SQLite might be inside your new cell phone or MP3 player or in the set-top box from your cable company. At least one copy of SQLite is probably found on your home computer; it comes built in on Apple s Mac OS X and on most versions of Linux, and it gets added to Windows when you install any of dozens of third-party software titles. SQLite backs many websites thanks in part to its inclusion in the PHP5 programming language. And SQLite is also known to be used in aircraft avionics, modeling and simulation programs, industrial controllers, smart cards, decision-support packages, and medical information systems. Since there are no reporting requirements on the use of SQLite, there are without doubt countless other deployments that are unknown to me. Much credit for the popularity of SQLite belongs to Michael Owens. Mike s articles on SQLite in The Linux Journal (June 2003) and in The C/C++ Users Journal (March 2004) int- duced SQLite to countless programmers. The traffic at the SQLite website jumped noticeably after each of these articles appeared."
Synopsis
This is the first book to devote complete coverage to the most recent release of the popular embedded open source database SQLite. The book acts as both an ideal tutorial and reference guide. It offers experienced database developers a thorough overview of its capabilities and APIs, yet is mindful of newcomers who may be making their first foray into the database environment with SQLite.
Significant material is devoted to SQLite internals, helping readers understand how to take full advantage of its features while minimally impacting resource consumption. SQLite has seen a rash of press coverage due to its increasing use within numerous high-profile projects such as Apple's Safari, and forthcoming versions of the Mozilla Project's Firefox browser, and Thunderbird mail client.