struct sqlite3_vtab

Every virtual table module implementation uses a subclass of this object to describe a particular instance of the virtual table. Each subclass will be tailored to the specific needs of the module implementation. The purpose of this superclass is to ... 

1. Introduction An imposter table is a table that is attached to the same b-tree as an index. An imposter table allows the content of an index to be queried or modified as if the index were an ordinary table. Imposter ... 

sqlite3_create_module(), sqlite3_create_module_v2()

These routines are used to register a new virtual table module name. Module names must be registered before creating a new virtual table using the module and before using a preexisting virtual table for the module. The module name is ... 

1. Introduction A virtual table is an object that presents an SQL table interface but which is not stored in the database file, at least not directly. The virtual table mechanism is a feature of SQLite that allows SQLite to access and ... 

sqlite3_vtab_nochange()

If the sqlite3_vtab_nochange(X) routine is called within the xColumn method of a virtual table, then it might return true if the column is being fetched as part of an UPDATE operation during which the column value will not change ... 

1. Introduction Every SQLite database contains a single "schema table" that stores the schema for that database. The schema for a database is a description of all of the other tables, indexes, triggers, and views that are contained within the database. The ... 

Rowid Tables 1.0 Definition A "rowid table" is any table in an SQLite schema that is not a virtual table, and is not a WITHOUT ROWID table. Most tables in a typical SQLite database schema are rowid tables. Rowid ... 

The UNION virtual table (hereafter: "union-vtab") is a virtual table that makes multiple independent rowid tables tables look like a single large table. The tables that participate in a union-vtab can be in the same database file, or ... 

sqlite3_vtab_collation()

This function may only be called from within a call to the xBestIndex method of a virtual table. This function returns a pointer to a string that is the name of the appropriate collation sequence to use for text comparisons ... 

1. Overview The generate_series(START,STOP,STEP) table-valued function is a loadable extension included in the SQLite source tree, and compiled into the command-line shell. The generate_series() table has one visible result column named "value" holding integer values and a ...