Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
6.2.1. Contentless FTS4 Tables
... In some cases, for
example if the MATCH expression in a SELECT query matches zero rows, there
may be no error at all even if a statement does refer to column values
other than docid.
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA case_sensitive_like
PRAGMA case_sensitive_like = boolean;
The default behavior of the LIKE operator is to ignore case
for ASCII characters. Hence, by default 'a' LIKE 'A' is
true. The case_sensitive_like pragma installs a new application-defined
LIKE function that is either case sensitive ...
|
|
35% Faster Than The Filesystem
(fasterthanfs.html)
2. How These Measurements Are Made
... You can omit that option to compare the
performance of SQLite running SQL statements.
In that case, the SQLite still out-performs direct reads, though
by not as much as when using sqlite3_blob_read().
The --blob-api option is ignored for ...
|
|
The Lemon LALR(1) Parser Generator
(lemon.html)
... Reentrancy is especially
important for SQLite since some SQL statements make recursive calls
to the parser. For example, when parsing a CREATE TABLE statement,
SQLite invokes the parser recursively to generate an INSERT statement
to make a new entry in ...
|
|
ALTER TABLE
(lang_altertable.html)
... In the case of the DROP COLUMN command, the
only text modified is that the column definition is removed from the
CREATE TABLE statement. The DROP COLUMN command will fail if there
are any traces of the column in other ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
3. Virtual Table Details
... Both word and pattern can contain unicode characters
and can be mixed case.
rank
This is the rank of the word, as specified in the
original INSERT statement.
distance
This is an edit distance or Levenshtein distance going
from the ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... This includes the case where the UPDATE operation is attempted after
an earlier call to the conflict handler function returned
SQLITE_CHANGESET_REPLACE.
It is safe to execute SQL statements, including those that write to the
table that the callback related to ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
4.2. Deferred Foreign Key Constraints
... If the current statement is not inside an explicit transaction (a
BEGIN/COMMIT/ROLLBACK block), then an implicit
transaction is committed
as soon as the statement has finished executing. In this case deferred
constraints behave the same as immediate constraints ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
3. Checklist For Choosing The Right Database Engine
... In this rule, "application" means the code that issues SQL statements.
If the "application" is an application server and
if the content resides on the same physical machine as the application server,
then SQLite might still be appropriate even though ...
|
|
SQLite Older News
(oldnews.html)
... The slight slowdown for small CREATE INDEX
statements might be recovered in a future release. ORDER BY and GROUP BY
operations should now be faster for all cases, large and small.
The query planner has been enhanced to do a ...
|
Page generated by FTS5 in about 165.58 ms.