2. Advantages Of SQLite Archives  ... ZIP Archives and Tarballs are limited to storing only files. 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 ... 

4. VFS Implementations  ... and opening and for reading and/or writing, converting filenames into their canonical form. The sqlite3_vfs object also contains methods for obtaining randomness from the operating system, for suspending a process (sleeping) and for finding the current date and time ... 

 ... This document concerns only changes and enhancements to SQLite that are intentionally and deliberately contributed back to the SQLite website. For the purposes of this document, "SQLite software" shall mean any computer source code, documentation, makefiles, test scripts, or other ... 

sqlite3_close(), sqlite3_close_v2()

 ... 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(), sqlite3_open16(), or sqlite3_open_v2(), and not previously closed. Calling sqlite3_close() or sqlite3_close_v2() with a NULL pointer argument is ... 

sqlite3_uri_parameter(), sqlite3_uri_boolean(), sqlite3_uri_int64(), sqlite3_uri_key()

 ... A database filename pointer created by the SQLite core and passed into the xOpen() method of a VFS implementation, or A filename obtained from sqlite3_db_filename(), or A new filename constructed using sqlite3_create_filename(). If the F parameter is not one of ... 

sqlite3_backup_init(), sqlite3_backup_step(), sqlite3_backup_finish(), sqlite3_backup_remaining(), sqlite3_backup_pagecount()

 ... The S and M arguments passed to sqlite3_backup_init(D,N,S,M) identify the database connection and database name of the source database, respectively. The source and destination database connections (parameters S and D) must be different or else sqlite3_backup_init ... 

 ... When paired with NULL:   AND evaluates to 0 (false) when the other operand is false; and   OR evaluates to 1 (true) when the other operand is true. The IS and IS NOT operators work like = and ... 

 ... The main reasons for providing functions other than strftime() are for convenience and for efficiency. The julianday() and unixepoch() functions return real and integer values respectively, and do not incur the format conversion costs or inexactitude resulting from use of ... 

sqlite3_commit_hook(), sqlite3_rollback_hook()

 ... The sqlite3_commit_hook(D,C,P) and sqlite3_rollback_hook(D,C,P) functions return the P argument from the previous call of the same function on the same database connection D, or NULL for the first call for each function on D ... 

sqlite3_column_database_name(), sqlite3_column_database_name16(), sqlite3_column_table_name(), sqlite3_column_table_name16(), sqlite3_column_origin_name(), sqlite3_column_origin_name16()

These routines provide a means to determine the database, table, and table column that is the origin of a particular result column in SELECT statement. The name of the database or table or column can be returned as either a ...