Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
1.1. Syntax
... ROWID"
to the end of the CREATE TABLE statement. For example:
CREATE TABLE IF NOT EXISTS wordcount(
word TEXT PRIMARY KEY,
cnt INTEGER
) WITHOUT ROWID;
As with all SQL syntax, the case of the keywords does not matter.
One can ...
|
|
CREATE VIEW
(lang_createview.html)
... Description
The CREATE VIEW command assigns a name to a pre-packaged
SELECT statement.
Once the view is created, it can be used in the FROM clause
of another SELECT in place of a table name.
If the "TEMP" or ...
|
|
The SQLITE_STMT Virtual Table
(stmt.html)
2.1. Columns
... The original SQL text of the prepared statement. If the prepared
statement is compiled using the sqlite3_prepare() interface, then
the SQL text might not have been saved, in which case this column
will be NULL.
ncol:
The number of columns ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... Each wildcard has an associated number which is its sequence in the
statement or the "nnn" in the case of a "?nnn" form.
It is allowed for the same wildcard
to occur more than once in the same SQL statement ...
|
|
C API: Start a read transaction on an historical snapshot
(c3ref/snapshot_open.html)
sqlite3_snapshot_open()
... If there
is already a read transaction open on schema S, then the database handle
must have no active statements (SELECT statements that have been passed
to sqlite3_step() but not sqlite3_reset() or sqlite3_finalize()).
SQLITE_ERROR is returned if either of these ...
|
|
Deterministic SQL Functions
(deterministic.html)
... Special-case Processing For Date/Time Functions
The built-in date and time functions of SQLite are a special case.
These functions are usually considered deterministic. However, if
these functions use the string "now" as the date, or if they ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
3. Advanced Usage
... This section describes features designed for more esoteric use cases. These
features all involve specifying extra optional parameters following the SQL
statement as part of the CREATE VIRTUAL TABLE command. An optional parameter
is specified using its name, followed by ...
|
|
Why SQLite Uses Bytecode
(whybytecode.html)
3.1. Query Planning Decisions Can Be Deferred Until Runtime
When a prepared statement is bytecode, once the bytecode has been generated,
the algorithm is fixed and cannot be subsequently changed without completely
rewriting the bytecode.
This is not the case with a tree-of-objects prepared
statement. A tree ...
|
|
The WITH Clause
(lang_with.html)
... In the diagram above, initial-select means one or more
non-recursive SELECT statements and recursive-select means
one or more recursive SELECT statements. The most common case is for there
to be exactly one initial-select and exactly one ...
|
|
Isolation In SQLite
(isolation.html)
... In some cases, it might depend
on the content of the database file, too. There is no good way to know whether
or not a SELECT statement will see changes that were made to the database
by the same database ...
|
Page generated by FTS5 in about 156.39 ms.