API Functions

This is a list of nearly every supported function call in the SQLite API. The only functions that have been omitted are those related to internal developer testing and those functions that are considered obsolete.

Many of the functions return an SQLite result code. The topic of result codes is somewhat complex and has a lot of history. For a full discussion, see Result Codes and Error Codes. The basics are pretty easy, however. Nearly every function returns SQLITE_OK if the function succeeded. Most other result codes indicate some type of error, but not all of them. For example, the codes SQLITE_ROW and SQLITE_DONE are used to indicate a specific program state. A result of SQLITE_MISUSE means that the application is using the API incorrectly. This is usually caused by the developer misunderstanding how the API works, or because of a program flow or logic error that causes an unintended call sequence.

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.