1.2. Untrusted SQLite Database Files  ... Run PRAGMA integrity_check or PRAGMA quick_check on the database as the first SQL statement after opening the database files and prior to running any other SQL statements. Reject and refuse to process any database file containing errors. Enable the PRAGMA ... 

3. Activating And Configuring WAL Mode  ... To convert to WAL mode, use the following pragma: PRAGMA journal_mode=WAL; The journal_mode pragma returns a string which is the new journal mode. On success, the pragma will return the string "wal". If the conversion to WAL could not ... 

sqlite3_keyword_count(), sqlite3_keyword_name(), sqlite3_keyword_check()

 ... For example, the statement "CREATE TABLE BEGIN(REPLACE,PRAGMA,END);" is accepted by SQLite, and creates a new table named "BEGIN" with three columns named "REPLACE", "PRAGMA", and "END". Nevertheless, best practice is to avoid using keywords as identifiers. Common ... 

 ... However, when not in write-ahead log mode, the page_size and/or auto_vacuum properties of an existing database may be changed by using the page_size and/or pragma auto_vacuum pragmas and then immediately VACUUMing the database. When in write-ahead ... 

 ... The page size and cache size can also be set or changed at run-time using the page_size pragma and cache_size pragma, respectively. 3.0 Possible Negative Consequences Of This Change The minimum size of an SQLite database is one ... 

sqlite3_busy_timeout()

 ... for a particular database connection at any given moment. If another busy handler was defined (using sqlite3_busy_handler()) prior to calling this routine, that other busy handler is cleared. See also: PRAGMA busy_timeout See also lists of Objects, Constants, and Functions.

sqlite3_compileoption_used(), sqlite3_compileoption_get()

 ... SQL functions sqlite_compileoption_used() and sqlite_compileoption_get() and the compile_options pragma. See also lists of Objects, Constants, and Functions.

sqlite3_changes(), sqlite3_changes64()

 ... the sqlite3_total_changes() interface the count_changes pragma the changes() SQL function the data_version pragma See also lists of Objects, Constants, and Functions.

sqlite3_busy_handler()

 ... The sqlite3_busy_handler() interface is used to implement sqlite3_busy_timeout() and PRAGMA busy_timeout. If the busy callback is NULL, then SQLITE_BUSY is returned immediately upon encountering the lock. If the busy callback is not NULL, then the callback might be invoked with ... 

sqlite3_soft_heap_limit64(), sqlite3_hard_heap_limit64()

 ... The memory allocation limits can also be adjusted using PRAGMA soft_heap_limit and PRAGMA hard_heap_limit. The heap limits are not enforced in the current implementation if one or more of following conditions are true: The limit value is set to zero ...