Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.13. The function method
... The function will not be accessible to
triggers, views, CHECK constraints, generated columns, or index
expressions. This option is recommended for all application-defined
SQL functions, and is highly recommended for any SQL
function that has side effects or that ...
|
|
Recent SQLite News
(news.html)
... Without the fix, it is possible for
a multi-way join that uses a Bloom filters for two or more tables in
the join to enter an infinite loop if the key constraint on one of those
tables contains a ...
|
|
Database File Format
(fileformat.html)
2.6. Storage Of The SQL Database Schema
... 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 ...
|
|
Window Functions
(windowfunctions.html)
2.3. The FILTER Clause
... show
join-constraint:
show
join-operator:
show
ordering-term:
show
result-column:
show
table-or-subquery:
show
window-defn:
show
frame-spec:
show
type-name:
show
signed-number:
show
If a FILTER clause is provided, then only rows for which ...
|
|
Distinctive Features Of SQLite
(different.html)
... SQLite also provides statements such as
REPLACE and the
ON CONFLICT clause that allow for
added control over the resolution of constraint conflicts.
SQLite supports ATTACH and
DETACH commands that allow multiple
independent databases to be used together in the ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.5. Statement Journal Files
... But after modifying the first 50 rows, the UPDATE hits
a constraint violation which should block the entire statement.
The statement journal is used to undo the first 50 row changes
so that the database is restored to the state ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
3. Benefits Of WITHOUT ROWID Tables
... Of course, in a
real-world schema, there will typically be secondary indices and/or
UNIQUE constraints, and the situation is more complicated. But even then,
there can often be space and performance advantages to using WITHOUT ROWID
on tables ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
6. Binding Parameters and Reusing Prepared Statements
... SQLite allows a parameter wherever a string literal,
blob literal, numeric constant, or NULL is allowed
in queries or data modification statements. (DQL or DML)
(Parameters may not be used for column or table names,
or as values for constraints ...
|
|
Profiling SQL Queries
(profile.html)
2. Simple Cases - Rows, Loops and Cycles
... This is because SQLite
was able to discard rows from t1 that did not match the "t1.b<=100"
constraint.
The "cycles" measurements are based on the
CPU time-stamp counter
, and so are a good proxy for wall ...
|
|
Implementation Limits For SQLite
(limits.html)
... An "index" in
the previous sentences means an index created explicitly using a
CREATE INDEX statement or implicit indices created by UNIQUE and
PRIMARY KEY constraints.
Whenever a database is opened, the entire schema is scanned and parsed
and a ...
|
Page generated by FTS5 in about 162.99 ms.