The Definitive Guide to SQLite / Edition 1

Hardcover (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $3.24
Usually ships in 1-2 business days
(Save 94%)
Other sellers (Hardcover)
  • All (12) from $3.24   
  • New (4) from $45.11   
  • Used (8) from $3.24   

Overview

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in 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 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.

Read More Show Less

Product Details

  • ISBN-13: 9781590596739
  • Publisher: Apress
  • Publication date: 5/24/2006
  • Edition number: 1
  • Pages: 464
  • Product dimensions: 10.00 (w) x 7.00 (h) x 1.00 (d)

Meet 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.
Read More Show Less

Table of Contents

Ch. 1 Introducing SQLite 1
Ch. 2 Getting started 17
Ch. 3 The relational model 47
Ch. 4 SQL 73
Ch. 5 Design and concepts 171
Ch. 6 The core C API 205
Ch. 7 The extension C API 255
Ch. 8 Language extensions 301
Ch. 9 SQLite internals 341
Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews
  • Posted Sat Apr 10 00:00:00 EDT 2010

    Truly definitive, but with practical problems

    This is truly a definitive boon on SQLite - it covers everything from the basics of the SQL query language to the C and Python API of SQLite itself. There are numerous examples, and the book is well written and comprehensive throughout. At the same time, the presentation is compact and to the point.

    There are, however, some issues with usability of the book. The index is virtually useless as many important terms are not indexed at all. Many others are listed as sub-items to less-than-obvious primary terms.

    The production quality of the hardcover leaves nothing to be desired. The paper feels solid and the binding is robust.

    Overall, I would highly recommend the book for its complete coverage of all things SQLite, but caution that it may take a while to find what you're looking for.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)