The Definitive Guide to SQLite

×

The Definitive Guide to SQLite

Close

The Definitive Guide to SQLite
Apress | ISBN 1590596730 | 2006 Year | 464 Pages | PDF | English | 5.7 Mb

The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database.

Book Description

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, 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.


You'll learn about SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl.
The book thoroughly covers SQLite internals to help you take full advantage of its features while minimally impacting resource consumption.
Author Mike Owens is the original creator of Pysqlite, the popular Python extension for SQLite.



About the Author
Mike Owens is the IT director for a major real estate firm in Fort Worth, Texas, where he's charged with the development and management of the company's core systems. His prior experience includes time spent at Oak Ridge National Laboratory as a process design engineer, and at Nova Information Systems as a C++ programmer. He is the original creator of Pysqlite, the Python extension for SQLite. Mike earned his bachelor's degree in chemical engineering from the University of Tennessee in Knoxville.