Here is what you do to start experimenting with SQLite without having to do a lot of tedious reading and configuration: Download The Code Get a copy of the prebuilt binaries for your machine, or get a copy of the ... 

 ... 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 ... 

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 ... 

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 ... 

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 ... 

 ... 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 ... 

4. OR Optimizations WHERE clause constraints that are connected by OR instead of AND can be handled in two different ways. If a term consists of multiple subterms containing a common column name and separated by OR, like this: column = expr1 OR column ... 

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 ...