Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
Overview
FTS3 and FTS4 are SQLite virtual table modules that allow users to perform
full-text searches on a set of documents. The most common (and effective)
way to describe full-text searches is "what Google, Yahoo, and Bing do
with ...
|
|
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 ...
|
|
SQLite Older News
(oldnews.html)
... This means, for example, that it is now possible
to use the REPLACE command on FTS3/FTS4 and RTREE tables.
The FTS4 full-text index extension has been enhanced to support
the FTS4 prefix option and the FTS4 order option ...
|
|
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 ...
|
|
Compile-time Options
(compile.html)
... SQLITE_FTS3_MAX_EXPR_DEPTH=N
This macro sets the maximum depth of the search tree that corresponds to
the right-hand side of the MATCH operator in an FTS3 or FTS4 full-text
index. The full-text search uses a recursive algorithm, so ...
|
Page generated by FTS5 in about 34.46 ms.