1. Introduction  ... An SQLite Archive is an ordinary SQLite database file that contains the following table as part of its schema: CREATE TABLE sqlar( name TEXT PRIMARY KEY, -- name of the file mode INT, -- access permissions mtime INT, -- last modification time sz ... 

3.2. Comparison of dates stored as separate fields  ... CREATE TABLE info( year INT, -- 4 digit year month INT, -- 1 through 12 day INT, -- 1 through 31 other_stuff BLOB -- blah blah blah ); When dates are stored this way, row value comparisons provide a convenient way to compare dates: SELECT ... 

sqlite3_blob_open()

This interfaces opens a handle to the BLOB located in row iRow, column zColumn, table zTable in database zDb; in other words, the same BLOB that would be selected by: SELECT zColumn FROM zDb.zTable WHERE rowid = iRow; Parameter zDb ... 

1.1. Untrusted SQL Inputs  ... Note that SQLite uses its built-in printf() internally to help it format the sql column in the sqlite_schema table. For that reason, no table, index, view, or trigger definition can be much larger than the precision limit. You can ... 

struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ... 

 ... The colUsed field indicates which columns of the virtual table may be required by the current scan. Virtual table columns are numbered from zero in the order in which they appear within the CREATE TABLE statement passed to sqlite3_declare_vtab(). For ... 

SQLITE_STMTSTATUS_FULLSCAN_STEP, SQLITE_STMTSTATUS_SORT, SQLITE_STMTSTATUS_AUTOINDEX, SQLITE_STMTSTATUS_VM_STEP, SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN ... 

 ... SQLITE_STMTSTATUS_FULLSCAN_STEP This is the number of times that SQLite has stepped forward in a table as part of a full table scan. Large numbers for this counter may indicate opportunities for performance improvement through careful use of indices. SQLITE_STMTSTATUS_SORT This ... 

 ... But rows that are deleted because of a DROP TABLE are not counted. SQLite implements the command "DELETE FROM table" (without a WHERE clause) by dropping the table then recreating it. This is much faster than deleting the elements of ... 

 ... The table schema might look something like this: CREATE TABLE slide( pageNumber INTEGER, -- The slide page number slideContent TEXT -- Slide content as XML or JSON ); CREATE INDEX slide_pgnum ON slide(pageNumber); -- Optional The content of each slide could still be ... 

2. Usage The SQLITE_DBPAGE virtual table read/write table that provides direct access to the underlying disk file on a page-by-page basis. The virtual table appears to have a schema like this: CREATE TABLE sqlite_dbpage( pgno INTEGER PRIMARY KEY, data ... 

 ... Frequent inserts, updates, and deletes can cause the database file to become fragmented - where data for a single table or index is scattered around the database file. Running VACUUM ensures that each table and index is largely stored contiguously within ...