Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Virtual Table Configuration Options
(c3ref/c_vtab_constraint_support.html)
SQLITE_VTAB_CONSTRAINT_SUPPORT, SQLITE_VTAB_INNOCUOUS, SQLITE_VTAB_DIRECTONLY, SQLITE_VTAB_USES_ALL_SCHEMAS
... SQLITE_VTAB_USES_ALL_SCHEMAS
Calls of the form
sqlite3_vtab_config(db,SQLITE_VTAB_USES_ALL_SCHEMA) from within the
the xConnect or xCreate methods of a virtual table implementation
instruct the query planner to begin at least a read transaction on
all schemas ("main", "temp", and any ATTACH ...
|
|
Window Functions
(windowfunctions.html)
2.1. The PARTITION BY Clause
For the purpose of computing window functions, the result set
of a query is divided into one or more "partitions". A partition consists
of all rows that have the same value for all terms of the PARTITION BY clause
in ...
|
|
C API: Impose A Limit On Heap Size
(c3ref/hard_heap_limit64.html)
sqlite3_soft_heap_limit64(), sqlite3_hard_heap_limit64()
... The sqlite3_soft_heap_limit64() interface sets and/or queries the
soft limit on the amount of heap memory that may be allocated by SQLite.
SQLite strives to keep heap memory utilization below the soft heap
limit by reducing the number of pages ...
|
|
Powersafe Overwrite
(psow.html)
... The powersafe overwrite property for individual databases can be
specified as the database is opened using the "psow" query parameter
with a URI filename. For example, to always assume powersafe
overwrite for a file (perhaps to ensure maximum write performance ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... The SQLITE_FCNTL_PERSIST_WAL opcode is used to set or query the
persistent Write Ahead Log setting. By default, the auxiliary
write ahead log (WAL file) and shared memory
files used for transaction control
are automatically deleted when the latest connection to ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
3. Benefits Of WITHOUT ROWID Tables
... Consider querying this table to find the number of occurrences of the
word "xsync".:
SELECT cnt FROM wordcount WHERE word='xsync';
This query first has to search the index B-Tree looking for any entry
that contains the matching value ...
|
|
Version Numbers in SQLite
(versionnumbers.html)
1.2. The Historical Numbering System (Before 2015-10-14)
... The 3.7.17 to 3.8.0 change was a result of rewrite known as the
next generation query planner.
The minor version number Y was historically incremented for new
features and/or new interfaces that did not significantly ...
|
|
Architecture of SQLite
(arch.html)
... The code generator, and especially the logic in where*.c
and in select.c, is sometimes called the
query planner. For any particular SQL statement, there might be
hundreds, thousands, or millions of different algorithms to compute
the answer. The ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
... API calls to submit queries or specify data modification
normally require substantially fewer bits to be passed
back and forth than are transferred to/from
the database file to store or find the data.
Query result retrieval will normally require ...
|
|
SQLite Keywords
(lang_keywords.html)
... NO
NOT
NOTHING
NOTNULL
NULL
NULLS
OF
OFFSET
ON
OR
ORDER
OTHERS
OUTER
OVER
PARTITION
PLAN
PRAGMA
PRECEDING
PRIMARY
QUERY
RAISE
RANGE
RECURSIVE
REFERENCES
REGEXP
REINDEX
RELEASE
RENAME
REPLACE
RESTRICT
RETURNING
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP ...
|
Page generated by FTS5 in about 197.02 ms.