Book by Michael Owens covering SQLite from getting started and SQL to the core and extension C APIs, language extensions and internals.
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.
| Author | Michael Owens |
|---|---|
| Publisher | Apress |
| ISBN-13 | 978-1-59059-673-9 |
| ISBN-10 | 1-59059-673-0 |
The book was written by Michael Owens, who is also the original creator of PySQLite.
The foreword was written by Richard Hipp and is dated April 11, 2006.
Chapter 6 covers the core C API and Chapter 7 covers the extension C API.
It includes Appendix A, an SQL reference, Appendix B, a C API reference, and Appendix C on Codd's 12 rules.