Skip to main content
SpringerLink
Log in
Apress

The Definitive Guide to SQLite

  • Book
  • © 2006

Overview

Authors:
  1. Michael Owens
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • The first book to comprehensively cover version 3, the most recent release of the popular embedded open source database SQLite (http://www.sqlite.org/). SQLite has seen a rash of press in recent months due to its increasing use within numerous high-profile projects such as Apple's Safari, and forthcoming versions of the Mozilla Project's Firefox browser, and Thunderbird mail client

  • Readers are presented with introductions to the SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl

  • Because of SQLite's common use within projects requiring minimal memory footprints, significant material is devoted to SQLite internals, helping readers understand how to take full advantage of its features while minimally impacting resource consumption

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 54.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 84.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (9 chapters)

  1. Front Matter

    Pages i-xxi
    Download chapter PDF

  2. Introducing SQLite

    Pages 1-16

  3. Getting Started

    Pages 17-45

  4. The Relational Model

    Pages 47-72

  5. SQL

    Pages 73-170

  6. Design and Concepts

    Pages 171-203

  7. The Core C API

    Pages 205-253

  8. The Extension C API

    Pages 255-299

  9. Language Extensions

    Pages 301-340

  10. SQLite Internals

    Pages 341-362

  11. Back Matter

    Pages 363-440
    Download chapter PDF
Back to top

Keywords

About this book

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.

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.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation