Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Virtual Database Engine of SQLite
(vdbe.html)
... This template will be expanded considerably as we consider
additional complications such as joins, compound selects, using
indices to speed the search, sorting, and aggregate functions
with and without GROUP BY and HAVING clauses.
But the same basic ideas will ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... An SQLITE_OPEN_TRANSIENT_DB holds a database table that
SQLite creates automatically in order to evaluate a subquery or
ORDER BY or GROUP BY clause. Both TEMP_DB and TRANSIENT_DB databases
are private and are deleted automatically. TEMP_DB databases last
for the duration ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... SQLITE_ENABLE_ORDERED_SET_AGGREGATES
This option enables support for the "WITHIN GROUP ORDER BY"
ordered-set aggregate syntax. For example:
SELECT percentile_cont(0.75) WITHIN GROUP (ORDER BY x) FROM tab;
The above is the SQL-standard way to compute the 75th-percentile ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.3. The transaction method
... The transaction command can be used to group together several SQLite
commands in a safe way. You can always start transactions manually using
BEGIN, of
course. But if an error occurs so that the COMMIT or ROLLBACK are never
run ...
|
|
Database File Format
(fileformat.html)
1.6. B-tree Pages
... If there is an isolated
group of 1, 2, or 3 unused bytes within the cell content area, those bytes
comprise a fragment. The total number of bytes in all fragments is stored
in the fifth field of the b ...
|
Page generated by FTS5 in about 68.59 ms.