Small. Fast. Reliable.
Choose any three.

These pages defined the C-language interface to SQLite.

This is not a tutorial. These pages are designed to be precise, not easy to read. For a tutorial introduction see SQLite In 3 Minutes Or Less and/or the Introduction To The SQLite C/C++ Interface.

This version of the C-language interface reference is broken down into small pages for easy viewing. The same content is also available as a single large HTML file for those who prefer that format.

The content on these pages is extracted from comments in the source code.

The interface is broken down into three catagories:

  1. List Of Objects. All abstract objects and datatypes used by the SQLite library. There are a handful of objects, but only three which most users need to be aware of: A database connection object sqlite3, prepared statement object sqlite3_stmt, and the 64-bit integer type sqlite3_int64.

  2. List Of Constants. Numeric constants just by SQLite and represented by #defines in the sqlite3.h header file. These constants are things such as numeric return parameters from various interfaces (ex: SQLITE_OK or flags passed into functions to control behavior (ex: SQLITE_OPEN_READONLY).

  3. List Of Functions. Functions and/or methods operating on the objects and using and/or returning constants. There are many function, but most applications only use a handful.


This page last modified 2009/02/18 18:03:35 UTC