The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3.1. Inputs
The main thing that the SQLite core is trying to communicate to
the virtual table is the constraints that are available to limit
the number of rows that need to be searched. The aConstraint[] array
contains one entry for each ...
|
The SQLite R*Tree Module
(rtree.html)
4.1.1. Limitations
For auxiliary columns, only the name of the column matters.
The type affinity is ignored.
Constraints such as NOT NULL, UNIQUE, REFERENCES, or CHECK
are also ignored. However, future versions
of SQLite might start paying attention to the type affinity ...
|
SQLite Archive Files
(sqlar.html)
2. Advantages Of SQLite Archives
... ZIP Archives and Tarballs are limited to storing only files. An
SQLite Archive stores files plus whatever other tabular
and/or relational data seems useful to the application.
An SQLite Archive is transactional.
Updates are atomic and durable, even if ...
|
The Use Of assert() In SQLite
(assert.html)
2. Examples
... At https://sqlite.org/src/artifact/18a53540aa3?ln=5512-5516
we have a test for two pre-conditions that are true only because
of the limited scope of use of the sqlite3BtreeRowCountEst() function.
Future enhancements to SQLite might use sqlite3BtreeRowCountEst ...
|
The Spellfix1 Virtual Table
(spellfix1.html)
4. Algorithm
... To limit
the search space, X is converted to a k2-like key using the
equivalent of:
key = spellfix1_phonehash(lower(spellfix1_translit(X)))
This key is then limited to "scope" characters. The default scope
value is 4, but an alternative scope ...
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... This maximum length can be changed at compile-time
using the SQLITE_MAX_LENGTH compile-time option, or at run-time using
the sqlite3_limit(db,SQLITE_LIMIT_LENGTH,...) interface. The
SQLITE_TOOBIG error results when SQLite encounters a string or BLOB
that exceeds the compile ...
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... Application Interface
After a sequence of changes that define a single undo/redo step,
invoke the undo::barrier command to define the limit of that step.
In an interactive program, you can call undo::event after any change
and undo ...
|
Temporary Files Used By SQLite
(tempfiles.html)
4. Other Temporary File Optimizations
... Each temporary file gets its own private page cache with its
own SQLITE_DEFAULT_TEMP_CACHE_SIZE page limit.
|
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 ...
|
Page generated by FTS5 in about 80.67 ms.