1. Overview The SQLITE_DBPAGE extension implements an eponymous-only virtual table that provides direct access to the underlying database file by interacting with the pager. SQLITE_DBPAGE is capable of both reading and writing any page of the database. Because interaction is through ... 

1. Overview The following command causes REPLICA to become a copy of ORIGIN: $ sqlite3_rsync ORIGIN REPLICA ?OPTIONS? Use the --help or -? flag to see the complete list of options. Option flags may appear before, after, or between the ORIGIN and REPLICA arguments ... 

1. Overview The RETURNING clause is not a statement itself, but a clause that can optionally appear near the end of top-level DELETE, INSERT, and UPDATE statements. The effect of the RETURNING clause is to cause the statement to ... 

1. Overview The graph below shows the number of CPU cycles used by SQLite on a standard workload, for versions of SQLite going back about 10 years. Recent versions of SQLite use about one third as many the CPU cycles compared to ... 

1. Overview The DBSTAT virtual table is a read-only eponymous virtual table that returns information about the amount of disk space used to store the content of an SQLite database. Example use cases for the DBSTAT virtual table include the sqlite3_analyzer ... 

1. Overview An UPDATE statement is used to modify a subset of the values stored in zero or more rows of the database table identified by the specified as part of the UPDATE statement. 2. Details If the UPDATE statement ... 

1. Overview The percentile extension provides four aggregate functions that compute a percentile score and/or the median value for a distribution. The percentile extension is not in the SQLite core. It is not part of the amalgamation. The percentile extension is ... 

1. Overview The "swarmvtab" virtual table allows the user to query a large number of tables (hereafter "component" tables) with similar schemas but distinct ranges of rowid values as if they were a single database table. The tables may be (and usually ... 

1. Overview Compile SQLite like this: Unix and Mac → ./configure && make Windows → nmake /f Makefile.msc The commands above will build the amalgamation and the Command Line Interface (aka: CLI). There are no (required) dependencies, so the commands above should ... 

1. Overview The zipfile module provides read/write access to simple ZIP archives. The current implementation has the following restrictions: Does not support encryption. Does not support ZIP archives that span multiple files. Does not support zip64 extensions. The only compression algorithm ...