Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Foreign Key Support
(foreignkeys.html)
... A transaction savepoint (a non-nested savepoint that was
opened while there was not currently an open transaction), on the
other hand, is subject to the same restrictions as a COMMIT - attempting
to RELEASE it while the database is in ...
|
|
Architecture of SQLite
(arch.html)
... WAL mode logic is in the separate
wal.c. In-memory caching is implemented by the
pcache.c and pcache1.c files.
The interface between page cache subsystem
and the rest of SQLite is defined by the header file pager ...
|
|
SQLite Older News
(oldnews.html)
... when a database is opened using URI filenames
and the mode=memory query parameter
then the database is an in-memory database, just as if it had
been named ":memory:". But, if shared cache mode is enabled, then
all other ...
|
|
Custom Builds Of SQLite
(custombuild.html)
... For systems that do not
support recursive mutexes, it is recommended that applications operate
in single-threaded mode only. If this is not possible, SQLite provides
an alternative recursive mutex implementation built on top of the
standard "fast" mutexes of ...
|
|
Database File Format
(fileformat.html)
... In current versions of SQLite, both of
these values are 1 for rollback journalling modes and 2 for WAL
journalling mode. If a version of SQLite coded to the current
file format specification encounters a database file where the read ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
... Hence, the virtual table mechanism
could not be used in a database that has shared cache mode enabled.
The sqlite3_create_module() interface would return an error if
shared cache mode is enabled. That restriction was relaxed
beginning with SQLite version 3 ...
|
|
The RBU Extension
(rbu.html)
... The target database may not be in WAL mode.
The target database may not contain indexes on expressions.
Indexes on expressions are supported beginning with SQLite 3.30.0
(2019-10-04).
No other writes may occur on the target ...
|
|
TH3
(th3.html)
... TH3 exercises SQLite in a variety of run-time configurations
(UTF8 vs UTF16, different pages sizes, varying journal modes, etc.)
TH3 achieves 100% branch test coverage (and 100%
MC/DC)
over the SQLite core.
(Test coverage of extensions such as ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
... For the LIKE operator, if case_sensitive_like mode is enabled then
the column must indexed using BINARY collating sequence, or if
case_sensitive_like mode is disabled then the column must indexed
using built-in NOCASE collating sequence.
If the ESCAPE option is ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... 10 Close 0 0
The instruction Close closes a
cursor previously opened as P1 (0, the only open cursor). If P1 ...
|
Page generated by FTS5 in about 84.50 ms.