Saturday, July 2, 2022

The Definitive Guide to SQLite

by Mike Owens
Hardcover: 464 pages
Publisher: Apress; 1 edition (May 25, 2006)
Language: English
ISBN-10: 1590596730
ISBN-13: 978-1590596739
Product Dimensions: 9.2 x 7.2 x 1.2 inches

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.

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.

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.

    Posted on 2006-05-26 10:13:18 pm

#1 2008-05-29 08:56:37 pm

Craig Smith
From:: Tacoma, WA
Registered: 2005-05-16
Posts: 1027

The Definitive Guide to SQLite

This book is designed for people that understand C, at least to a fair degree.  It does a very good job of not only covering the SQLite API, but also giving the reader a good look at just HOW the package does its magic.  There is very little actual SQL in this book; the reader is expected to understand the basics as well as know how to write queries already.

I think that this text's strength is in its completeness of instruction for using the various commands and functions that allow a developer to utilize the program in whatever application he or she is creating.  The examples are top notch and printed in a font size that is easy to read and understand.  The only issue I had with the examples were that the downloaded files did not precisely match what was in the book.

I also did not like the index.  I actually have been creating a number of index entries on my own, due to the fact that I can't find what I am looking for 5 days after I read something.

I do not know C, and am an Objective-C neophyte.  Still, I found this book an interesting read, and very helpful personally in a couple of projects that I am building.

Craig Smith



Board footer

Powered by FluxBB

RSS (new topics) RSS (active topics)