sqlite3_snapshot_recover()

If a WAL file remains on disk after all database connections close (either through the use of the SQLITE_FCNTL_PERSIST_WAL file control or because the last process to have the database opened exited without calling sqlite3_close()) and a new connection is ... 

sqlite3_snapshot_open()

 ... A call to sqlite3_snapshot_open() will fail to open if the specified snapshot has been overwritten by a checkpoint. In this case SQLITE_ERROR_SNAPSHOT is returned. If there is already a read transaction open when this function is invoked, then the same ... 

 ... Mozilla, developer of the popular open-source Firefox web browser, and Symbian, the market-leading open operating system for advanced data-enabled smartphones, both deploy the SQLite database engine in their products. As charter members of the Consortium, Mozilla and ... 

3.3. Recognized Query Parameters  ... vfs=NAME The vfs query parameter causes the database connection to be opened using the VFS called NAME. The open attempt fails if NAME is not the name of a VFS that is built into SQLite or that has been ... 

4. Typical Usage Of Core Routines And Objects An application will typically use sqlite3_open() to create a single database connection during initialization. Note that sqlite3_open() can be used to either open existing database files or to create and open new database files. While many applications use only a ... 

struct sqlite3

Each open SQLite database is represented by a pointer to an instance of the opaque structure named "sqlite3". It is useful to think of an sqlite3 pointer as an object. The sqlite3_open(), sqlite3_open16(), and sqlite3_open_v2() interfaces are its constructors, and ... 

2. Example 1: Loading and Saving In-Memory Databases /* ** This function is used to load the contents of a database file on disk ** into the "main" database of open database connection pInMemory, or ** to save the current contents of the database opened by pInMemory into ** a database file on ... 

 ... Open-Source, not Open-Contribution SQLite is open-source, meaning that you can make as many copies of it as you want and do whatever you want with those copies, without limitation. But SQLite is not open-contribution. In order ... 

sqlite3_close(), sqlite3_close_v2()

 ... If an sqlite3 object is destroyed while a transaction is open, the transaction is automatically rolled back. The C parameter to sqlite3_close(C) and sqlite3_close_v2(C) must be either a NULL pointer or an sqlite3 object pointer obtained from sqlite3_open ... 

 ... The function calls to pay attention to here are the call to sqlite3_open() on line 22 which opens the database, sqlite3_exec() on line 28 that executes SQL commands against the database, and sqlite3_close() on line 33 that closes the database ...