Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS5 Extension
(fts5.html)
Changes to SELECT statements
The "docid" alias does not exist. Applications must use "rowid"
instead.
The behaviour of queries when a column-filter is specified both as
part of the FTS query and by using a column as the LHS of a MATCH
operator ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.3. Querying An R*Tree Index
... The R*Tree
implementation just makes some kinds of queries especially
efficient. Queries against the primary key are efficient:
SELECT * FROM demo_index WHERE id=28269;
Of course, an ordinary SQLite table will also do a query against its
integer primary ...
|
|
Transaction
(lang_transaction.html)
... A read transaction is started
by a SELECT statement, and a write transaction is started by
statements like CREATE, DELETE, DROP, INSERT, or UPDATE (collectively
"write statements"). If a write statement occurs while
a read transaction is active, then the ...
|
|
The SQLITE_STMT Virtual Table
(stmt.html)
2. Usage
... that can be directly
queried to access information about all prepared statements on the
current database connection. For example:
SELECT * FROM sqlite_stmt;
A statement such as the above can be run immediately prior to invoking
sqlite3_close() to confirm that all ...
|
|
8+3 Filenames
(shortnames.html)
... Changing Filesystems
The recommended fix for this problem is to select a different
filesystem. These days, there is a huge selection of high-performance,
reliable, patent-free filesystems that support long filenames.
Where possible, it is recommended that embedded devices ...
|
|
C API: Source Of Data In A Query Result
(c3ref/column_database_name.html)
sqlite3_column_database_name(), sqlite3_column_database_name16(), sqlite3_column_table_name(), sqlite3_column_table_name16(), sqlite3_column_origin_name(), sqlite3_column_origin_name16()
These routines provide a means to determine the database, table, and
table column that is the origin of a particular result column in
SELECT statement.
The name of the database or table or column can be returned as
either a ...
|
|
Pointer Passing Interfaces
(bindptr.html)
2.3. Pointer Leaks
... reading
the values of pointers. In other words, subtypes on pointer values
prevent attacks using SQL statements like this:
SELECT snippet(x'6092310100000000') FROM t1 WHERE cx MATCH $pattern;
The BLOB argument to snippet() does not have the correct subtype ...
|
|
LoC Recommended Storage Format
(locrsf.html)
1.1. What Is A Recommended Storage Format?
... When selecting recommended storage formats, the following criteria are
considered (quoting from the LOC website):
Disclosure.
Degree to which complete specifications and tools for validating
technical integrity exist and are accessible to those creating and
sustaining digital content.
A spectrum ...
|
|
JSON Functions And Operators
(json1.html)
4.23.1. Examples using json_each() and json_tree()
... SELECT name FROM user WHERE phone LIKE '704-%'
UNION
SELECT user.name
FROM user, json_each(user.phone)
WHERE json_valid(user.phone)
AND json_each.value LIKE '704-%';
Consider a different database with "CREATE TABLE big(json JSON)".
To see a complete ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... We will use the following simple SELECT statement as our example:
SELECT * FROM examp;
The VDBE program generated for this SQL statement is as follows:
sqlite> EXPLAIN SELECT * FROM examp;
addr opcode ...
|
Page generated by FTS5 in about 165.27 ms.