Expand description
Virtual table and cursor traits (§9.3).
Virtual tables expose external data sources as SQL tables. They follow the SQLite xCreate/xConnect/xBestIndex/xFilter/xNext protocol.
These traits are open (user-implementable). Extension authors implement them to create custom virtual table modules.
§Cx on I/O Methods
Methods that perform I/O accept &Cx for cancellation and deadline
propagation. Lightweight accessors (eof, column, rowid) do not
require &Cx since they operate on already-fetched row data.
Structs§
- Column
Context - A context object passed to
VirtualTableCursor::columnfor writing the column value. - Index
Constraint - A single constraint from the WHERE clause that the planner is considering.
- Index
Constraint Usage - Per-constraint usage information set by
best_index. - Index
Info - Information exchanged between the query planner and virtual table during index selection.
- Index
Order By - A single ORDER BY term from the query.
- Transactional
Vtab State - Snapshot-backed transaction/savepoint state for mutable virtual tables.
Enums§
- Constraint
Op - Comparison operator for an index constraint.
Traits§
- Erased
Vtab Cursor - A type-erased virtual table cursor.
- Erased
Vtab Instance - A type-erased virtual table instance.
- Virtual
Table - A virtual table module.
- Virtual
Table Cursor - A cursor for scanning a virtual table.
- Vtab
Module Factory - A type-erased virtual table module factory.
Functions§
- module_
factory_ from - Create a
VtabModuleFactoryfrom aVirtualTabletype.