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.