Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
3.1.
Set Operations Using The Enhanced Query Syntax
The enhanced query syntax supports the AND, OR and NOT binary set operators.
Each of the two operands to an operator may be a basic FTS query, or the
result of another AND, OR or NOT set operation. Operators ...
|
|
SELECT
(lang_select.html)
... If there is more than one table or subquery in the FROM clause
then the contents of all tables and/or subqueries
are joined into a single dataset for the simple SELECT statement to operate on.
Exactly how the data ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... indicating an I/O error in the VFS layer
while trying to flush previously written content out of OS and/or
disk-control buffers and into persistent storage. In other words,
this code indicates a problem with the fsync() system ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA trusted_schema
... by views,
triggers, or in expressions of the schema such as CHECK constraints,
DEFAULT clauses, generated columns, expression indexes, and/or
partial indexes. This setting can also be controlled using
the sqlite3_db_config(db,SQLITE_DBCONFIG_TRUSTED_SCHEMA,...)
C-language interface.
In order to ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... A zero-terminated string containing the text of one or more
SQL statements and/or queries to be processed.
A pointer to a callback function which is invoked once for each
row in the result of a query. This argument ...
|
|
Recent SQLite News
(news.html)
... 2023-09-11 - Version 3.43.1
Version 3.43.1 is a patch release that fixes a few small inaccuracies that were
discovered in the the 3.43.0 and/or 3.42.0 releases after the 3.43 ...
|
|
Database File Format
(fileformat.html)
1.3.4. Reserved bytes per page
... These extra bytes are
used, for example, by the SQLite Encryption Extension to store a nonce
and/or cryptographic checksum associated with each page. The
"reserved space" size in the 1-byte integer at offset 20 is the number
of ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... A changeset consists of zero or more INSERT, UPDATE and/or DELETE changes,
each representing a change to a single row of an attached table. An INSERT
change contains the values of each field of a new database row. A ...
|
|
Command Line Shell For SQLite
(cli.html)
6. Opening Database Files
... The ".dbtotxt" dot-command and/or the dbtotxt command-line tool can be used to generate
the appropriate text for a database. The --hexdb option is intended for use by the
SQLite developers for testing purposes. We do not know ...
|
|
SQLite FTS5 Extension
(fts5.html)
3.1. FTS5 Strings
... As an FTS5 bareword that is not "AND", "OR" or "NOT" (case sensitive).
An FTS5 bareword is a string of one or more consecutive characters that
are all either:
Non-ASCII range characters (i.e. unicode codepoints greater
than 127 ...
|
Page generated by FTS5 in about 175.79 ms.