This review is sort of a long time coming. The book is simply called SQLite. SQLite (the book) was written by Chris Newman (0-672-32685-X) and is one of the books in the Developer’s Library from InformIT. Books in the Developer’s Library are designed for programmers as high quality references and tutorials on technical subjects. I believe that this is the first book that I have read and personally owned in the series. The book’s “tag-line” so to speak is:
A practical guide to using, administering, and programming the database bundled with PHP 5
and hits it right on the mark. While the book is small it packs a punch. Chris Newman makes it a point to go into detail where needed and skip the parts that are not necessary. One one of my gripes about programming books is that they contain too much programming and logic basics.
The book is split up into three logical parts, Part I consisting of General SQLite Usage, Part II Using SQLite Programming Interfaces and Part III SQLite Administration.
Part I has four chapters the first not being entirely necessary for the SQL guru, but I learned a few things that I would not have known otherwise, and it was a quick read if you skip the basic SQL stuff. The second through forth chapters are on actually working with SQLite such as the structures, syntax / usage and query optimization.
Part II is a chapter for each interface (PHP, C/C++, Perl, Tcl and Python.) Whether you use each of these technologies or not is irrelevant since it is invaluable as a reference if you wished to use your existing databases with these languages. Reading all of these chapters are not needed if you have no intention of using the language right away.
Part III discusses administration and the SQLite Virtual Database Engine. For me just wanting to learn SQLite the section on the VDBE was a little overkill, but interesting none the less. I like that it was included and think it will be useful in the future.
Overall I think SQLite has a good balance for SQL newbies and seasoned gurus just wanting to quickly get up to speed and implement SQLite. It has everything I’ve needed and then some for my tinkering with SQLite.