Using SQLite

Appendix G. SQLite C API Reference

This appendix covers the data structures and functions that make up the C programming API. The appendix is designed to act as a reference, providing specific details about each function and data structure. It does not, however, provide a high-level overview of how all the parts fit together into a useful application. To understand the ideas and patterns behind the API, it is strongly recommended you review the material in Chapter 7.

Those items marked [EXP] should be considered experimental. This is not meant to imply that those functions and features are risky or untested, simply that they are newer, and there is some chance the interface may change slightly in a future version of SQLite. This is somewhat rare, but it does happen. Those functions not marked experimental are more or less set in stone. The behavior of a function may change, if it is found to have a minor bug, but the interface definition will not. The SQLite team has a very strong belief in backwards compatibility and will not change the behavior of an existing interface if there is any chance it might break existing applications. New features that require changes result in new interfaces, such as the _v2 version of some functions (for example, sqlite3_open_v2()). Generally, this makes upgrading the SQLite library used with an existing library a low-risk process.

The official documentation for the complete C programming interface can be found at http://www.sqlite.org/c3ref/intro.html ...