Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The CSV Virtual Table
(csv.html)
1. Overview
... One can use the CSV virtual table inside subqueries,
or common table expressions or add WHERE, GROUP BY, HAVING, ORDER BY,
and LIMIT clauses as required.
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3.1. Inputs
... In addition to WHERE clause constraints, the SQLite core also
tells the xBestIndex method about the ORDER BY clause.
(In an aggregate query, the SQLite core might put in GROUP BY clause
information in place of the ORDER BY clause ...
|
|
C API: Formatted String Printing Functions
(c3ref/mprintf.html)
sqlite3_mprintf(), sqlite3_vmprintf(), sqlite3_snprintf(), sqlite3_vsnprintf()
... The result is written into the
buffer supplied as the second parameter whose size is given by
the first parameter. Note that the order of the
first two parameters is reversed from snprintf(). This is an
historical accident that cannot ...
|
|
The SQLITE_STMT Virtual Table
(stmt.html)
2.1. Columns
... A positive value in this field may indicate an opportunity to improve
performance by adding an index that will cause the query results to
appear naturally in the desired order.
This field is equivalent to the SQLITE_STMTSTATUS_SORT value.
naidx:
This ...
|
|
The DBSTAT Virtual Table
(dbstat.html)
2. The "path" column of the dbstat virtual table
... ordered from left to right
so the pages to the left have smaller keys than the pages to the right.)
The next to left-most child of the root page is '/001', and so on,
each sibling page identified by ...
|
|
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 underlying VFS might choose to preallocate database
file space based on this hint in order to help writes to the database
file run faster.
The SQLITE_FCNTL_SIZE_LIMIT opcode is used by in-memory VFS that
implements sqlite3_deserialize() to set an ...
|
|
The Percentile Extension
(percentile.html)
3.4. The percentile_disc(Y,P) aggregate function
... The percentile_disc(Y,P) function is defined by SQL
standards. As with percentile_cont(), the prolix ordered-set aggregate syntax
is required, but that syntax is only supported by SQLite when SQLite is
compiled using the SQLITE_ENABLE_ORDERED_SET_AGGREGATES compile-time option.
This ...
|
|
C API: Device Characteristics
(c3ref/c_iocap_atomic.html)
SQLITE_IOCAP_ATOMIC, SQLITE_IOCAP_ATOMIC512, SQLITE_IOCAP_ATOMIC1K, SQLITE_IOCAP_ATOMIC2K, SQLITE_IOCAP_ATOMIC4K, SQLITE_IOCAP_ATOMIC8K ...
... The SQLITE_IOCAP_SEQUENTIAL property means that
information is written to disk in the same order as calls
to xWrite(). The SQLITE_IOCAP_POWERSAFE_OVERWRITE property means that
after reboot following a crash or power loss, the only bytes in a
file that were written ...
|
|
Implementation Limits For SQLite
(limits.html)
... The sqlite3_limit() interface allows internal databases managed by
trusted code to be unconstrained while simultaneously placing tight
limitations on databases created or controlled by untrusted external
code in order to help prevent a denial of service attack.
Maximum length of ...
|
|
Database Object Name Resolution
(lang_naming.html)
... The temp database is searched
first, followed by the main database, followed all attached databases in the
order that they were attached. The reference resolves to the first match
found. For example:
/* Add a table named 't1' to the temp ...
|
Page generated by FTS5 in about 220.31 ms.