mORMot Open Source

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,207

Website

SQLite3 : updates about FTS3 and upcoming FTS4

In order to prepare the upcoming 3.7.4. version, including FTS4, some code modifications have been made to the source code repository:
- added sqlite3_result_error() call to make wrong parameter count error explicit during SQL statement internal functions calls
- handles new FTS4 extension module - see http://sqlite.org/draft/fts3.html#section_1_1 - which is available since 3.7.4
- new RANK() function available in SQL statements for ranking FTS3/FTS4 with best performance (used by the new TSQLRest.FTSMatch() overloaded method) - see http://www.sqlite.org/draft/fts3.html#appendix_a
- new class function TSQLRecord.SimpleFieldsCount
- FTS3Match method renamed FTSMatch, in order to be used without hesitation for both FTS3 and FTS4 classes
- new overloaded FTSMatch method, accepting ranking of MATCH, using the new RANK internal function - see http://www.sqlite.org/draft/fts3.html#appendix_a
- new TSQLRecordFTS4 class, to handle new FTS4 extension module - see http://sqlite.org/draft/fts3.html#section_1_1 - which is available since 3.7.4

Source c and obj files are not yet updated, so FTS4 won't work yet. But framework's code is ready.