Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
Appendix A: Search Application Tips
... SELECT title FROM documents
WHERE documents MATCH <query>
ORDER BY countintegers(offsets(documents)) DESC
LIMIT 10 OFFSET 0
The query above could be made to run faster by using the FTS matchinfo
function to determine the number of ...
|
|
SQLite Older News
(oldnews.html)
... sqlite3_randomness() provides access to SQLite's internal
pseudo-random number generator, sqlite3_limit() allows size
limits to be set at run-time on a per-connection basis, and
sqlite3_context_db_handle() is a convenience routine that allows
an application-defined SQL function implementation ...
|
|
SQLite Version 3 Overview
(version3.html)
... A limited form of table-level locking is now also available in SQLite.
If each table is stored in a separate database file, those separate
files can be attached to the main database (using the ATTACH command)
and the combined ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... Another solution might be to limit
the number of times that any single query could be reattempted (to say
100). Although this might be less efficient than one might wish, the
situation in question is not likely to occur often.
|
|
SQL Language Expressions
(lang_expr.html)
... Hexadecimal integer literals are interpreted as 64-bit
two's-complement integers and are thus limited
to sixteen significant digits of precision.
Support for hexadecimal integers was added to SQLite
version 3.8.6 (2014-08-15).
For backwards compatibility ...
|
|
How SQLite Is Tested
(testing.html)
4.3. Boundary Value Tests
SQLite defines certain limits on its operation, such as the
maximum number of columns in a table, the maximum length of an
SQL statement, or the maximum value of an integer. The TCL and TH3 test
suites both contains numerous ...
|
|
ALTER TABLE
(lang_altertable.html)
... Overview
SQLite supports a limited subset of ALTER TABLE.
The ALTER TABLE command in SQLite allows
these alterations of an existing table:
it can be renamed;
a column can be renamed;
a column can be added to it;
or
a ...
|
|
SQLite FTS5 Extension
(fts5.html)
6.2. The 'crisismerge' Configuration Option
... The difference between this option and the 'automerge' option is that when
the 'automerge' limit is reached FTS5 only begins to merge the b-trees
together. Most of the work is performed as part of subsequent INSERT,
UPDATE or DELETE ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
4.2. Shadow Tables
... The underlying R-Tree implementation uses bounding boxes to limit the search
space. Then the geoploy_overlap() and/or geopoly_within() routines further
refine the search to the exact answer.
This page last modified on 2023-12-05 14:43:20 UTC
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... The disabled
features include but are not limited to the following:
The PRAGMA writable_schema=ON statement.
The PRAGMA journal_mode=OFF statement.
The PRAGMA schema_version=N statement.
Writes to the sqlite_dbpage virtual table.
Direct writes to shadow tables.
SQLITE_DBCONFIG_WRITABLE_SCHEMA
The SQLITE_DBCONFIG_WRITABLE_SCHEMA ...
|
Page generated by FTS5 in about 122.85 ms.