Authors:
The first book to comprehensively cover version 3, the most recent release of the popular embedded open source database SQLite (http://www.sqlite.org/). SQLite has seen a rash of press in recent months 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
Readers are presented with introductions to the SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl
Because of SQLite's common use within projects requiring minimal memory footprints, significant material is devoted to SQLite internals, helping readers understand how to take full advantage of its features while minimally impacting resource consumption
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (9 chapters)
-
Front Matter
-
Back Matter
About this book
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.
About the author
Bibliographic Information
Book Title: The Definitive Guide to SQLite
Authors: Michael Owens
DOI: https://doi.org/10.1007/978-1-4302-0172-4
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Mike Owens 2006
Hardcover ISBN: 978-1-59059-673-9Published: 24 May 2006
Softcover ISBN: 978-1-4302-1166-2Published: 05 November 2014
eBook ISBN: 978-1-4302-0172-4Published: 06 December 2006
Edition Number: 1
Number of Pages: XXI, 440
Topics: Database Management, Software Engineering/Programming and Operating Systems