Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The CSV Virtual Table
(csv.html)
1. Overview
... Typical usage of the CSV virtual table from the
command-line shell would be something like this:
.load ./csv
CREATE VIRTUAL TABLE temp.t1 USING csv(filename='thefile.csv');
SELECT * FROM t1;
The first line of the script above causes ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
13. SQLite Distinguishes Between Integer And Text Literals
SQLite says that the following query returns false:
SELECT 1='1';
It does this because an integer is not a string.
Every other major SQL database engine says this is true, for reasons
that the creator of SQLite does not ...
|
|
List Of Virtual Tables
(vtablist.html)
2. Virtual Tables
... fsdir
A table-valued function returning one row for each file in a
selected file hierarchy of the host computer. Used by the
CLI to help implement the .archive command.
FTS3
A high-performance full-text search index.
FTS5
A ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.1.2. Table-valued functions
A virtual table that contains hidden columns can be used like
a table-valued function in the FROM clause of a SELECT statement.
The arguments to the table-valued function become constraints on
the HIDDEN columns of the virtual table ...
|
|
The RBU Extension
(rbu.html)
2.2.1. The RBU Database Schema
... Tables within the RBU database are processed in order by
name (from smallest to largest according to the BINARY collation sequence),
so the order in which target tables are updated is influenced by the selection
of the <integer> ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... In this case SQLite simply
selects one of those other connections arbitrarily and issues the
unlock-notify callback when that connection's transaction is finished.
Whether the call to sqlite3_step() was blocked by one or many connections,
when the corresponding ...
|
|
The Checksum VFS Shim
(cksumvfs.html)
5. Verification Of Checksums
... quick_check" command
will find it. To verify that checksums are actually enabled
and running, use SQL like the following:
SELECT count(*), verify_checksum(data)
FROM sqlite_dbpage
GROUP BY 2;
There are three possible outputs from the verify_checksum()
function: 1, 0, and ...
|
|
The Lemon LALR(1) Parser Generator
(lemon.html)
2.2. Lemon Customizations Especially For SQLite
... In support of the 100% MC/DC testing goal for SQLite,
the parser code generated by Lemon has no unreachable branches,
and contains extra (compile-time selected) instrumentation useful
for measuring test coverage.
Lemon supports conditional compilation of grammar file ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SQLITE_OMIT_COMPOUND_SELECT
This option is used to omit the compound SELECT functionality.
SELECT statements that use the
UNION, UNION ALL, INTERSECT or EXCEPT compound SELECT operators will
cause a parse error.
An INSERT statement with multiple values in the VALUES clause ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA reverse_unordered_selects
PRAGMA reverse_unordered_selects;
PRAGMA reverse_unordered_selects = boolean;
When enabled, this PRAGMA causes many SELECT statements without
an ORDER BY clause to emit their results in the reverse order from what
they normally would. This can help debug applications that are
making invalid ...
|
Page generated by FTS5 in about 181.97 ms.