Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... 3.2e-16 value. The end result is
an imprecise result for the sum(). The decimal_sum() aggregate
generates an exact answer, at the cost of additional CPU and memory usage.
Note also that decimal_sum() is not built into the SQLite ...
|
|
The Session Extension
(sessionintro.html)
1.3. Limitations
Prior to SQLite version 3.17.0, the session extension only worked with
rowid tables, not WITHOUT ROWID tables. As of 3.17.0, both
rowid and WITHOUT ROWID tables are supported. However, extra steps are
needed to record primary ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.3. Specifying Which VFS To Use
There is always one VFS which is the default VFS. On unix systems,
the "unix" VFS comes up as the default and on windows it is "win32".
If no other actions are taken, new database connections will make use
of ...
|
|
The Schema Table
(schematab.html)
3. Interpretation Of The Schema Table
... UNIQUE and PRIMARY KEY constraints on tables cause SQLite to create
internal indexes with names of the form "sqlite_autoindex_TABLE_N"
where TABLE is replaced by the name of the table that contains the
constraint and N is an integer beginning with ...
|
|
TH3
(th3.html)
3. Generating A Test Program
... SQLite 3.8.11 2015-05-15 04:13:15 56ef98a04765c34c1c2f3ed7a6f03a732f3b886e
The output begins with a report of the SQLITE_SOURCE_ID
(cross-checked again sqlite3_sourceid()) for the
SQLite under test and the compile-time options used as reported
by sqlite3_compileoption_get(). The ...
|
|
ANALYZE
(lang_analyze.html)
... The PRAGMA optimize command was first introduced with
SQLite 3.18.0 (2017-03-28) and is a no-op for all prior releases
of SQLite. The PRAGMA optimize command was significantly enhanced
in SQLite 3.46.0 (2024-05 ...
|
|
DELETE
(lang_delete.html)
... Prior to SQLite version 3.6.5 (2008-11-12), the truncate optimization
also meant that the sqlite3_changes() and
sqlite3_total_changes() interfaces
and the count_changes pragma
will not actually return the number of deleted rows.
That problem has been fixed as ...
|
|
Internal Versus External BLOBs
(intern-v-extern-blob.html)
... New measurements for SQLite version 3.19.0
(2017-05-22) show that SQLite is about
35% faster than direct disk I/O for
both reads and writes of 10KB blobs.
The matrix below shows the time needed to read ...
|
|
NULL Handling in SQLite
(nulls.html)
NULL Handling in SQLite Versus Other Database Engines
The goal is
to make SQLite handle NULLs in a standards-compliant way.
But the descriptions in the SQL standards on how to handle
NULLs seem ambiguous.
It is not clear from ...
|
|
Implementation Limits For SQLite
(limits.html)
... To prevent excessive memory allocations,
the maximum value of a host parameter number is SQLITE_MAX_VARIABLE_NUMBER,
which defaults to 999 for SQLite versions prior to 3.32.0 (2020-05-22)
or 32766 for SQLite versions after 3.32.0.
The ...
|
Page generated by FTS5 in about 339.61 ms.