An Introduction To The SQLite C/C++ Interface

This article provides an overview and roadmap to the C/C++ interface
to SQLite.

Early versions of SQLite were very easy to learn since they only
supported 5 C/C++ interfaces. But as SQLite has grown in capability,
new C/C++ interfaces have been added so that now there
are over 185 distinct APIs. This can be overwhelming to a new programmer.
Fortunately, most of the C/C++ interfaces in SQLite are very specialized
and never need to be used. Despite having so many
entry points, the core API is still relatively simple and easy to code to.
This article aims to provide all of the background information needed to
easily understand how SQLite works.

A separate document, The SQLite C/C++ Interface,
provides detailed
specifications for all of the various C/C++ APIs for SQLite. Once
the reader
understands the basic principles of operation for SQLite,
that document should be used as a reference
guide. This article is intended as introduction only and is neither a
complete nor authoritative reference for the SQLite API.