Small. Fast. Reliable.
Choose any three.

本内容定义了SQLite的C语言接口。
These pages define the C-language interface to SQLite.

这并不是一个简易指南,这些内容是非常精确的,不易读的。如果想要简易介绍,参见SQLite 3分钟入门SQLite C/C++接口简介
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.

这一版的C语言接口参考被分割为多个小页面以方便阅读。如果喜欢一个页面的人,也可以在一个大 HTML 文件中找到相同的内容。
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 categories:

  1. 对象列表。这是SQLite库中使用的所有抽象对象和数据类型的列表。一共大概有数十个对象,但是最重要的三个对象是:数据库连接对象sqlite3,预编译语句对象sqlite3_stmt和64位整数类型sqlite3_int64
    List Of Objects. This is a list of all abstract objects and datatypes used by the SQLite library. There are couple dozen objects in total, but the three most important objects are: A database connection object sqlite3, prepared statement object sqlite3_stmt, and the 64-bit integer type sqlite3_int64.

  2. 常量列表。这里是SQLite中使用的数值常量列表,这些都定义在sqlite3.h头文件中。这些常量中有各种接口的数值返回值(例如:SQLITE_OK),也有传入函数来控制行为的标志(例如:SQLITE_OPEN_READONLY)。
    List Of Constants. This is a list of numeric constants used 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. This is a list of all functions and methods operating on the objects and using and/or returning constants. There are many functions, but most applications only use a handful.