The Definitive Guide to SQLite is the perfect book about SQLite. It covers everything needed to start working with SQLite including installation, using the SQLite shell, and programming with SQLite using six different language extensions.
— Joe Topjian, Adminspotting
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.
Youll 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.
Customer Reviews
Average Rating:
Rating: - Best available source on SQLite
This is the best available source on SQLite 3. It thoroughly covers how this junior version RDBMS differs from the big boys (like Oracle, MS SQL, PostgreSQL, etc.) It covers especially well the unusual variable typing and the special role of SQLite as an embedded relational database. For my purposes, the book spends too much time on the internals and the background C and C++. I wish it had covered in more detail the language extensions for embedding SQLite in Perl, Python, Ruby, Java, Tcl, and PHP; ... Read More
Rating: - Worth the Money, but ...
I read this book cover-to-cover, except for most of the C API material. It contains a useful SQL overview, along with Sqlite3 specifics. I have done corporate database programming in my younger days; but even so, the overview was a helpful refresher. However, a person current in SQL would consider this material fluff.
That said, the Sqlite3 specifics make the book worth the price. It is written well enough, and I enjoyed the read. I'm a perl guy, and I was disappointed that there wasn't ... Read More
Rating: - This is the "Missing Manual" for SQLite!
Whether you are new to SQLite or even new to SQL genereally, this book will have you using SQLite -- fast. SQLite is used in products and projects ranging from mobile devices to Firefox to Apple's Leopard to Google's Android. Getting to that level might take a little longer. :) A neophyte, I read straight through and found the quasi-historical introductory chapters on data modeling helpful. If you already know SQL and the theory behind it, go ahead and dive right into the details of SQLite. The API reference ... Read More
Rating: - Comments from a new SQLite/TCL developer...
I am writing this review after 4 weeks or so of receiving the book. I have been developing a project on the weekends during that interval.
I bought this book to use in conjunction with TCL for organizing a lot of online data obtained from web scraping for my business needs. I am an experienced C programmer (20+ years), but relatively new to both TCL and SQL. I was under the impression that SQLite was a fairly complete subset of MySQL, both from this book and other online hype. But from my limited exposure ... Read More
Rating: - Fantastic!
Folks, I don't have a lot of time to write a long review. I usually don't bother writing them at all. But, this is a *terrific* book. My advice: Use Sqlite. It's awesome for its size! Use Python. What an amazing language! Use PySqlite for the binding to Sqlite from Python. And, *read this book*!!!!!! You won't find better documentation on this wonderful product. Thanks to Dr. Hipp for Sqlite and to Mike Owens for the original PySqlite and this book. Happy reading!
- Best available source on SQLite
- Fantastic!
