Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Distinctive Features Of SQLite
(different.html)
... Users of the database can view this
virtual machine language
by prepending the EXPLAIN keyword
to a query.
The use of a virtual machine in SQLite has been a great benefit to the
library's development. The virtual machine provides ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... SQLITE_CONFIG_ROWID_IN_VIEW
The SQLITE_CONFIG_ROWID_IN_VIEW option enables or disables the ability
for VIEWs to have a ROWID. The capability can only be enabled if SQLite is
compiled with -DSQLITE_ALLOW_ROWID_IN_VIEW, in which case the capability
defaults to on. This configuration option queries the ...
|
|
The WITH Clause
(lang_with.html)
... Overview
Common Table Expressions or CTEs act like temporary views that exist
only for the duration of a single SQL statement. There are two kinds of
common table expressions: "ordinary" and "recursive". Ordinary
common table expressions are helpful for making ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.4. VFS Shims
From the point of view of the uppers layers of the SQLite stack, each
open database file uses exactly one VFS.
But in practice, a particular VFS might
just be a thin wrapper around another VFS that does the real ...
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1. The EXPLAIN QUERY PLAN Command
... The command-line shell will usually intercept this table and renders
it as an ASCII-art graph for more convenient viewing. To disable the
shells automatic graph rendering and to display EXPLAIN QUERY PLAN
output in its tabular format, run ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA table_list
PRAGMA table_list;
PRAGMA schema.table_list;
PRAGMA table_list(table-name);
This pragma returns information about the tables and views in the schema,
one table per row of output. The table_list pragma first appeared
in SQLite version 3.37.0 (2021-11 ...
|
|
Generated Columns
(gencol.html)
2.1. VIRTUAL versus STORED columns
... From the point of view of SQL, STORED and VIRTUAL columns are almost
exactly the same. Queries against either class of generated column
produce the same results. The only functional difference is that
one cannot add new STORED columns using ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
15. The Predicate Push-Down Optimization
... CREATE TABLE t1(a INT, b INT);
CREATE TABLE t2(x INT, y INT);
CREATE VIEW v1(a,b) AS SELECT DISTINCT a, b FROM t1;
SELECT x, y, b
FROM t2 JOIN v1 ON (x=a)
WHERE b BETWEEN ...
|
|
The SQLITE_DBPAGE Virtual Table
(dbpage.html)
2. Usage
... The SQLITE_DBPAGE table allows an application to view or replace the
raw binary content of each page of the database file.
No attempt is made to interpret the content of the page.
Content is returned byte-for-byte as it ...
|
|
Application-Defined SQL Functions
(appfunc.html)
3. Security Implications
... ALTER TABLE tab1 RENAME TO tab1_real;
CREATE VIEW tab1 AS SELECT * FROM tab1 WHERE system('rm -rf *') IS NOT NULL;
Then, when the application attempts to open the database, register the
system() function, then run an innocent query against the ...
|
Page generated by FTS5 in about 124.07 ms.