Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
The Definitive Guide to SQLite 2006th Edition
Use the Amazon App to scan ISBNs and compare prices.
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Customers Who Viewed This Item Also Viewed
Top Customer Reviews
I run away from most books with "Definitive" in the title, especially when they aren't heavy enough to break toes if I drop them on my foot. However, the author doesn't waste any space or get distracted with long explanations. In the 440 pages, he effectively covers all of SQLite, including its various language bindings and APIs. Although he created the initial Python bindings, Perl gets the most coverage (if you don't count the third of the book that talks about the C API for completely embedding SQLite into your own programs).
The front of the book covers basic database concepts. At times the subject matter gets a bit complicated, but the author has a clear style and easily explains the tough subjects. Without his command of the topic (as you'll find lacking with many database books), the explanations could have spun wildly out of control, taking the author for a ride. There's no question who's in charge here, though.
I've been using SQLite for a couple years and regularly delve into its documentation, and even I learned several things from this book. The handy SQL reference will keep me from waiting for websites to load, and I expect to have this book close at hand when I'm working with SQLite. It's one of the best database books I've encountered in a long time.
If you need a book on SQLite, The Definitive Guide to SQLite is the only one you should even consider.
I bet if you buy 1000 technical books in your life this will be the only one with an index that isn't alphabetical. Do your self a favor and buy the other 999 and skip this one.
Here's a suggestion for the next version:
ORDER BY KEYWORD ASC;
The answer thankfully, is not very much. As the author goes to great pains to reinforce many times, SQL as a logical Data Manipulation Language is specified as being completely divorced from the underlying implementation. While all SQL DBs have their own annoying extensions, incompatibilities and divergences from the standard, the underlying syntax and form of SQL is mostly constant. You may, in the course of reading this book, come under the impression you're actually reading two separate publications, with their chapters collated together and coarsely interleaved in the same binding. One is broadly about SQL and RDBMS's, the other is actually about SQLite. As it turns out, there isn't much specific to the topic of SQLite that really demands so much coverage, so with the declared intention of being "definitive", the author has written something of a ground up tutorial/reference that aims to introduce both SQL and SQLite to audiences thoroughly unfamiliar with either. Passing over the table of contents in the front of the book I found myself raising an eyebrow as I realized how narrow of a demographic this book aims to cater to; that is, programmers who know nothing of SQL or relational DB theory and yet feel compelled and ready to embed an RDBMS library into their applications. I happened to be one of these people, but I question the usefulness of much of this book to someone already familiar with SQL.Read more ›
If you are using MySQL or Postgres and don't need a distributed DBM, you need to look hard at SQLite. If you are using SQLite, you need this book.
I would recommend this book to anyone wanting to develop database enabled applications or light to medium traffic websites. I would also highly recommend it to anyone who wants to learn more about SQL or database theory in general.
Probably the most important thing I learned from this book is that 80% of us with databasing needs simply don't need to wrestle with a SQL server anymore.
Most Recent Customer Reviews
It is not necessarily always the easiest book to read..but its the best book you can have if you want to learn sqlite including sql from the ground up. Read morePublished 18 months ago by Highchi Papa
Fair Price for a good book - MySQL is my prime database but this single book is enough to cover my SQLite needsPublished on February 21, 2013 by The Trusted Sage
Not a bad book, however it was lacking in terms of examples -- "provides just the facts". I got better examples online for free.Published on November 10, 2012 by Gilbert Goodridge
As noted by the other reviewers, this Kindle edition is the 2006 1st edition, not the 2010 2nd edition. Absolutely do NOT bother with this edition, it's far too out of date. Read morePublished on March 14, 2012 by T. Hill
The title for this book should not be 'The Definitive Guide to SQLite', but 'Everything about SQL from the beginning of time'. Read morePublished on July 1, 2011 by Gonzalo Isaza
I bought the eBook version at the end of January 2011 and did not notice, or think to consider, that these buffoons would give me the 2006 version instead of the November 2010... Read morePublished on February 1, 2011 by Amazon Customer
Just recently bought this book. While the book is generally good, the index is awful--many key words are simply missing from the index. Read morePublished on July 2, 2010 by William Morton
I am very happy with this book -- it feels like a truly complete handbook for SQLite. My only beef with it is that the index is rather poor. Read morePublished on March 23, 2010 by Torsten Rohlfing
Owens' "Definitive Guide" is comprehensive and has all the information you need to take full advantage of SQLite. Read morePublished on December 25, 2009 by John Silver