... SQLite In 5 Minutes Or Less and/or the Introduction To The SQLite C/C++ Interface. This same content is also available as a single large HTML file. The SQLite interface elements can be grouped into three categories: List Of ... 

sqlite3_close(), sqlite3_close_v2()

 ... If the database connection is associated with unfinalized prepared statements, BLOB handlers, and/or unfinished sqlite3_backup objects then sqlite3_close() will leave the database connection open and return SQLITE_BUSY. If sqlite3_close_v2() is called with unfinalized prepared statements, unclosed BLOB handlers, and ... 

struct sqlite3_context

 ... The application-defined SQL function implementation will pass this pointer through into calls to sqlite3_result(), sqlite3_aggregate_context(), sqlite3_user_data(), sqlite3_context_db_handle(), sqlite3_get_auxdata(), and/or sqlite3_set_auxdata(). 26 Methods using this object: sqlite3_aggregate_context sqlite3_context_db_handle sqlite3_get_auxdata sqlite3_result_blob sqlite3_result_blob64 sqlite3_result_double sqlite3_result_error sqlite3_result_error16 sqlite3_result_error_code sqlite3_result_error_nomem sqlite3_result_error_toobig sqlite3_result_int sqlite3_result_int64 ... 

1.1. The New Version Numbering System (After 2015-10-14)  ... The third number Z is incremented for releases consisting of only small changes that implement performance enhancements and/or bug fixes. The rate of enhancement for SQLite over the previous five years (2010-2015) is approximately 6 increments of Y ... 

 ... The file format can be extended in future releases simply by adding new tables and/or columns, preserving backwards compatibility. Applications can leverage the full-text search and RTREE indexes and use triggers to implement an automated undo/redo stack ... 

 ... Experimental interfaces are subject to change and/or removal at any time. Deprecated interfaces should not be used in new code and might be removed in some future release.

 ... Consortium members can receive private email and/or telephone notifications and briefings covering new bugs or recently added features. The core developers are constantly watching out for the interests of consortium members and will attempt to protect those interests in ... 

2. Advantages Of SQLite Archives  ... An SQLite Archive stores files plus whatever other tabular and/or relational data seems useful to the application. An SQLite Archive is transactional. Updates are atomic and durable, even if there are crashes or power losses in the middle of ... 

sqlite3_stmt_scanstatus(), sqlite3_stmt_scanstatus_v2()

 ... Advanced applications can use this interface to compare the predicted and the measured performance and issue warnings and/or rerun ANALYZE if discrepancies are found. Since this interface is expected to be rarely used, it is only available if SQLite ... 

 ... Summary Newer versions of SQLite can always read and/or write database files created by older versions of SQLite, back to version 3.0.0 (2004-06-18). Older versions of SQLite back to version 3.0.0 can read ...