Small. Fast. Reliable.
Choose any three.
Search for:

Search results 1..10 of 29 for: fts3

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 ... 
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 ... 
The SQLite Amalgamation
(amalgamation.html)
2. The SQLite Amalgamation The SQLite library consists of 102 files of C code (as of Version 3.9.0 - 2015-10-14) in the core with 32 additional files that implement the FTS3, FTS5, RTREE, DBSTAT, JSON1, and RBU extensions. Of the 102 ... 
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 ... 
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_enable_fkey.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 two-argument version of 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 ... 
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 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 ... 
Compile-time Options
(compile.html)
8. Options To Disable Features Normally Turned On  ... SQLITE_DISABLE_FTS3_UNICODE If this C-preprocessor macro is defined, the unicode61 tokenizer in FTS3 is omitted from the build and is unavailable to applications. SQLITE_DISABLE_FTS4_DEFERRED If this C-preprocessor macro disables the "deferred token" optimization in FTS4. The "deferred token" optimization ... 
SQLite Release 3.8.9 On 2015-04-08
(releaselog/3_8_9.html)
 ... Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the ...