Apress The Definitive Guide to SQLite Book

Book by Michael Owens covering SQLite from getting started and SQL to the core and extension C APIs, language extensions and internals.


Apress The Definitive Guide to SQLite Book - cover page
Brand
Apress
Category
e-book
Document type
Other
Language
English
Pages
17
File format
PDF
File size
148 KB
Published
10 November, 2026
Updated
10 November, 2026
MD5 checksum
1689C1AF2CDE4857D0B8BF26133EDE80

About this manual

The Definitive Guide to SQLite is a book by Michael Owens, published by Apress with a foreword by Richard Hipp dated April 11, 2006. It is organized into nine chapters plus three appendices, moving from an introduction to SQLite and installation instructions to the relational model, SQL, design concepts, the C APIs and SQLite internals.

The later chapters cover the core C API (connecting, prepared queries, hooks, threads and shared cache mode), the extension C API (functions, aggregates and collating sequences), language extensions including Perl and Python (PySQLite and APSW), and SQLite internals. Appendix A is an SQL reference, Appendix B a C API reference, and Appendix C reproduces Codd's 12 rules.

What's inside

  • Introducing SQLite
  • Getting Started
  • The Relational Model
  • SQL
  • Design and Concepts
  • The Core C API
  • The Extension C API
  • Language Extensions
  • SQLite Internals
  • SQL Reference

Specifications

AuthorMichael Owens
PublisherApress
ISBN-13978-1-59059-673-9
ISBN-101-59059-673-0

Frequently asked questions

Who wrote The Definitive Guide to SQLite?

The book was written by Michael Owens, who is also the original creator of PySQLite.

Who wrote the foreword?

The foreword was written by Richard Hipp and is dated April 11, 2006.

Which chapters cover the SQLite C APIs?

Chapter 6 covers the core C API and Chapter 7 covers the extension C API.

What appendixes does the book include?

It includes Appendix A, an SQL reference, Appendix B, a C API reference, and Appendix C on Codd's 12 rules.

Download PDF (148 KB)

More Apress Manuals


View all Apress manuals →