The Definitive Guide to SQLite and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading The Definitive Guide to SQLite on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

The Definitive Guide to SQLite [Hardcover]

Mike Owens

List Price: CDN$ 59.02
Price: CDN$ 38.37 & FREE Shipping. Details
You Save: CDN$ 20.65 (35%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 2 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Thursday, August 21? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $29.72  
Hardcover CDN $38.37  
Save Up to 90% on Textbooks
Hit the books in Amazon.ca's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
Join Amazon Student in Canada


Book Description

May 24 2006 1590596730 978-1590596739 1

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.

Customers Who Bought This Item Also Bought


Product Details


Product Description

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.

Inside This Book (Learn More)
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.9 out of 5 stars  35 reviews
38 of 41 people found the following review helpful
4.0 out of 5 stars One of the best database books I've encountered Aug. 26 2006
By brian d foy - Published on Amazon.com
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.
14 of 15 people found the following review helpful
1.0 out of 5 stars Good content but good luck finding what you are looking for.. Oct. 5 2010
By Kennon A. Mccaa - Published on Amazon.com
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;
16 of 18 people found the following review helpful
5.0 out of 5 stars Excellent Book June 23 2006
By Clif Flynt - Published on Amazon.com
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.
12 of 13 people found the following review helpful
4.0 out of 5 stars Exhaustive, for better or worse. July 18 2009
By Cikkle - Published on Amazon.com
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.

Chapters 1 and 2 are boilerplate for introducing and setting up SQLite. Chapter 3 is an interesting but non-particular explanation of the Relational model. Chapter 4 is the centerpiece of the book and is a thorough introduction to SQL; while SQLite obviously is chosen as the reference implementation here, apart from the usual nuances this should not be at all unfamiliar to users of other relational DB's.

It isn't until chapter 5 that the book veers into territory solidly in the realm of SQLite. Chapters 5,6,7 and 8 all concern programming language interfaces to SQLite, however there's questionable utility to some of this. Chapter 5 "Design Concepts" redundantly presents the general structure of the API in pseudocode in advance of chapter 6 doing it all over again with the actual C function calls. 7 is the extension API, then chapter 8 continues over to the interfaces to higher level scripting and RAD languages. The repetition in this chapter is somewhat disquieting as unsurprisingly the general process of using SQLite is unchanged regardless of modules or the API in use, and in most languages there are reasonable standard generic DB interfaces to be used and there turns out not to be anything necessarily special about working with SQLite. Nonetheless, it's all there for reference and I found the examples in the Perl section useful while working on a project. The book ends with an overview of the internals of SQLite's compiler and VM backend. It's suggested in the chapter that an understanding of the engine may be of use to an application developer in reasoning about the workings of his or her queries, but I generally suspect that the point at which someone would need to concern themselves with the workings of the internal VM is the point at which they've either reached the performance limitations of their machine or the library, or else they've missed the forest for the trees and need to review the logical organization of their query. The remaining 60 or so pages are all reference appendices.

For programmers already familiar with SQL, most of what you should find of worth here is the API reference. Listings of function calls don't necessarily validate these chapters but the in-depth explanations of locking issues and race conditions do make these parts of the book worth the read versus just looking up the on-line documentation. Despite the criticisms earlier, if you actually fall within the boundaries of whom this book would provide instruction of unfamiliar topics to and need the long explanation of SQL given here, this is a good book for the topics it covers. The general SQL chapters are interesting and highly educational and well written, the SQLite chapters are good reference tutorials, but note that this book aims to be exhaustive and potentially retreads material that will likely already be known to advanced users.
12 of 13 people found the following review helpful
5.0 out of 5 stars Thoroughly Competent, Beginner to Novice. Feb. 1 2007
By William F. Pearson III - Published on Amazon.com
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.

Look for similar items by category


Feedback