SQLite FTS3 and FTS4 Extensions
(fts3.html)
Overview
... This article describes the deployment and usage of FTS3 and FTS4.
FTS1 and FTS2 are obsolete full-text search modules for SQLite. There are known
issues with these older modules and their use should be avoided.
Portions of the original ...
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
3. Limitations
... For several of SQLite's
bundled virtual tables (FTS3, FTS5, rtree and others), the surprising effects
may include corruption of the virtual table content.
If the --vtab option is passed to sqldiff.exe, then it ignores all
underlying shadow tables ...
|
Pointer Passing Interfaces
(bindptr.html)
3.1. Pointer Types
... The carray() function treats the
pointer as a pointer to an array of integers and returns each integer
one by one, thus leaking the content of the FTS3 cursor object. Since
the FTS3 cursor object contains pointers to other objects ...
|
SQLite FTS5 Extension
(fts5.html)
Appendix A: Comparison with FTS3/4
Also available is the similar but more mature FTS3/4 module.
FTS5 is a new version of FTS4 that includes various fixes and solutions for
problems that could not be fixed in FTS4 without sacrificing backwards
compatibility. Some of these ...
|
List Of Virtual Tables
(vtablist.html)
2. Virtual Tables
... in a
selected file hierarchy of the host computer. Used by the
CLI to help implement the .archive command.
FTS3
A high-performance full-text search index.
FTS5
A higher-performance full-text search index
generate_series
A table-valued function ...
|
SQLite Older News
(oldnews.html)
... The older
FTS3 virtual table is still fully supported, and should also run
faster. In addition, the new FTS4 virtual table is added. FTS4
follows the same syntax as FTS3 but holds additional metadata which
facilitates some performance improvements and ...
|
The SQLite Amalgamation
(amalgamation.html)
2. The SQLite Amalgamation
... The makefiles for SQLite have an "sqlite3.c" target for building the
amalgamation, to contain all C code for the core SQLite library and the
FTS3, FTS5, RTREE, DBSTAT, JSON1,
RBU and SESSION
extensions.
This file contains about 238K lines ...
|
The RBU Extension
(rbu.html)
2.2.3. Using RBU with FTS3/4 Tables
Usually, an FTS3 or FTS4 table is an example of a virtual table
with a rowid that works like a PRIMARY KEY. So, for the following FTS4 tables:
CREATE VIRTUAL TABLE ft1 USING fts4(addr, text);
CREATE VIRTUAL TABLE ft2 ...
|
Vulnerabilities
(cves.html)
3. Status Of Recent SQLite CVEs
... 05-22)
Malicious SQL statement causes a read of a NULL pointer in the
matchinfo() SQL function of the FTS3 extension, resulting in
denial of service.
(details)
CVE-2020-13631
3.32.0(2020-05-22)
Malicious SQL statement (an ...
|
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 ...
... SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
This option is used to enable or disable the
fts3_tokenizer() function which is part of the
FTS3 full-text search engine extension.
There should be two additional arguments.
The first argument is an integer which is 0 to disable ...
|
Page generated by FTS5 in about 30.93 ms.