4. Download Copies Of The Precompiled Amalgamation The amalgamation and the sqlite3.h header file are available on the download page as a file named sqlite-amalgamation-X.zip where the X is replaced by the appropriate version number. The download page also usually contains a tarball ... 

sqlite3_load_extension()

 ... If that does not work, it constructs a name "sqlite3_X_init" where the X is consists of the lower-case equivalent of all ASCII alphabetic characters in the filename from the last "/" to the first following "." and omitting any initial "lib ... 

sqlite3_wal_checkpoint_v2()

The sqlite3_wal_checkpoint_v2(D,X,M,L,C) interface runs a checkpoint operation on database X of database connection D in mode M. Status information is written back into integers pointed to by L and C. The M parameter must be ... 

 ... If the hard upper bound on mmap_size is non-zero at compilation time, it may still be reduced or zeroed at start-time using the sqlite3_config(SQLITE_CONFIG_MMAP_SIZE,X,Y) interface. The X and Y parameters must both be 64-bit ... 

1. Overview  ... For example, the abs(X) function always returns the same answer as long as its input X is the same. Non-deterministic functions might give different answers on each invocation, even if the arguments are always the same. The following ... 

sqlite3_enable_shared_cache()

 ... This method is disabled on MacOS X 10.7 and iOS version 5.0 and will always return SQLITE_MISUSE. On those systems, shared cache mode should be enabled per-database connection via sqlite3_open_v2() with SQLITE_OPEN_SHAREDCACHE. This interface is threadsafe on ... 

4.2. Checksum Algorithm  ... In other words, if the inputs are x(0) through x(N) then N must be odd. The checksum algorithm is as follows: s0 = s1 = 0 for i from 0 to n-1 step 2: s0 += x(i) + s1; s1 ... 

 ... CREATE TABLE t1(a); CREATE TABLE t2(x); SELECT * FROM (SELECT t1.a FROM t1 JOIN t2 ORDER BY t2.x LIMIT 1) ORDER BY 1; In version 3.5.9 the query above would return a single column named ... 

sqlite3_create_filename(), sqlite3_free_filename()

 ... The memory obtained from sqlite3_create_filename(X) must be released by a corresponding call to sqlite3_free_filename(Y). The P parameter in sqlite3_create_filename(D,J,W,N,P) should be an array of 2*N pointers to strings. Each pair of pointers ... 

3. Required and Suggested Database Indexes  ... CREATE TABLE parent2(a, b, PRIMARY KEY(a,b)); CREATE TABLE child8(x, y, FOREIGN KEY(x,y) REFERENCES parent2); -- Ok CREATE TABLE child9(x REFERENCES parent2); -- Error! CREATE TABLE child10(x,y,z, FOREIGN KEY(x,y,z) REFERENCES ...