Programming Books C Java PHP Python Learn more Browse Programming Books
The Definitive Guide to SQLite and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $59.99
  • Save: $22.11 (37%)
Only 5 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
The Definitive Guide to S... has been added to your Cart
FREE Shipping on orders over $35.
Used: Very Good | Details
Condition: Used: Very Good
Comment: Very Good/Very Good; Nice clean copy. No writing or highlighting. Unmarked inside and out. This item is fulfilled by Amazon and qualifies for Amazon Prime and Super Saver shipping.
Access codes and supplements are not guaranteed with used items.
Trade in your item
Get a $2.00
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

The Definitive Guide to SQLite Hardcover – May 23, 2006

ISBN-13: 978-1590596739 ISBN-10: 1590596730 Edition: 1st

Buy New
Price: $37.88
26 New from $20.62 32 Used from $8.65
Amazon Price New from Used from
Kindle
"Please retry"
Hardcover
"Please retry"
$37.88
$20.62 $8.65
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Frequently Bought Together

The Definitive Guide to SQLite + Using SQLite
Price for both: $79.07

Buy the selected items together
  • Using SQLite $41.19

Customers Who Viewed This Item Also Viewed

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Definitive Guide
  • Hardcover: 464 pages
  • Publisher: Apress; 1 edition (May 23, 2006)
  • Language: English
  • ISBN-10: 1590596730
  • ISBN-13: 978-1590596739
  • Product Dimensions: 1.2 x 7.2 x 10.2 inches
  • Shipping Weight: 1.9 pounds (View shipping rates and policies)
  • Average Customer Review: 3.9 out of 5 stars  See all reviews (35 customer reviews)
  • Amazon Best Sellers Rank: #911,329 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Mike Owens is the information technology 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.

More About the Author

Mike Owens is the IT director for Century 21 Mike Bowman in Grapevine, 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. Mike earned his bachelor's degree in chemical engineering from the University of Tennessee in Knoxville.

Customer Reviews

Very well written, great examples and easy to follow.
Scott in Pgh
It's supposed to be the definitive book, and it it's not I'm not sure where you'll find a better one!
K. Hansen
Not a bad book, however it was lacking in terms of examples -- "provides just the facts".
Gilbert Goodridge

Most Helpful Customer Reviews

38 of 41 people found the following review helpful By brian d foy VINE VOICE on August 26, 2006
Format: Hardcover
Mike Owens started writing about SQLite in Linux Magazine and C/C++ User's Journal, and he continues to show his clear and easy manner of explaining the features and use of this embedded database in this book, which Apress binds as a hardcover to show off its usefulness and longevity.

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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
14 of 15 people found the following review helpful By Kennon A. Mccaa on October 5, 2010
Format: Hardcover Verified Purchase
The book contains a fair amount of content and answered about 50% of the questions I had when I was getting started with SQLite. However, the index IS NOT ALPHABETICAL. It is insane. In this world when you are sitting at your computer trying to hack out something and you take the time to flip open a book the author should be very thankful. He/she should reward you with quick access to what you are looking for rather than torturing you with an arduous search through an index that is arbitrarily arranged by subjects. It makes no sense. You know the exact word you are looking for but you cannot find it. I guess that's what google is for. I've had to defer to google so many times that it is clear to me that this book was a waste of my money. It might be a good read if you are stuck on a desert island but it is inadequate if you are anywhere near a computer.

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:
SELECT KEYWORD
FROM WEIRD_CATEGORIZED_INDEX
ORDER BY KEYWORD ASC;
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
16 of 18 people found the following review helpful By Clif Flynt on June 23, 2006
Format: Hardcover
Definitive is definitely the right title for this book. It covers everything from the SQLite console commands to the interpreter language bindings (Tcl, Perl, Ruby, etc) to the C API. I've been using SQLite for several years, and learned new stuff before I hit page 30.

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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 13 people found the following review helpful By William F. Pearson III on February 1, 2007
Format: Hardcover
I bought this book thinking that I was going to need to reference a basic SQL source to fully understand the concepts. But, I found not only did it fully explain SQL and relational database theory, it also gave great advice on when one needed a full blown RDBMS.

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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 13 people found the following review helpful By Cikkle on July 18, 2009
Format: Hardcover Verified Purchase
It's reasonable to look over the description of this book and ask yourself what is so idiosyncratic and bizarre about SQLite that it merits a 464-page reference for developers to wrap their heads around it. Especially when as a stated goal, SQLite overtly aims to be simple, stripped-down and uncomplicated in use.

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 ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


What Other Items Do Customers Buy After Viewing This Item?