The Virtual Table Mechanism Of SQLite

sqlite.org

Tin mới

database connection

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

ALTER TABLE ... ADD COLUMN

CREATE VIRTUAL TABLE

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

create-virtual-table-stmt:

sqlite3_create_module()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

column definitions

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_vtab_cursor

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_index_info

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

SQLite source tree

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_vtab_config()

The xConnect and/or xCreate method can invoke sqlite3_vtab_config() with the SQLITE_VTAB_DIRECTONLY option to prevent the virtual table from being used from within triggers or views. This is recommended if the capability

SQLITE_VTAB_DIRECTONLY

The xConnect and/or xCreate method can invoke sqlite3_vtab_config() with the SQLITE_VTAB_DIRECTONLY option to prevent the virtual table from being used from within triggers or views. This is recommended if the capability

sqlite3_prepare_v3()

SQLITE_PREPARE_FROM_DDL

SQLITE_DBCONFIG_TRUSTED_SCHEMA

virtual table module

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_declare_vtab()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_libversion_number()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_vtab_collation()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

SQLITE_INDEX_CONSTRAINT_FUNCTION

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_vtab_rhs_value()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_vtab_distinct()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_result_blob()

sqlite3_last_insert_rowid()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_value_nochange(X)

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_vtab_nochange()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_db_config()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri

sqlite3_malloc64()

A virtual table is an object that is registered with an open SQLite database connection. From the perspective of an SQL statement, the virtual table object looks like any other table or view. But behind the scenes, queri