clach04/puren_tonbo

Full Text Search FTS

clach04 opened this issue · 0 comments

clach04 commented

See branch https://github.com/clach04/puren_tonbo/tree/fts_sqlite3_fts5

  • SQLite3 FTS5 implementation - https://www.sqlite.org/fts5.html #128
  • test problems, python3 -m puren_tonbo.tools.ptig puren_tonbo/tests/demo_notes ensure search for "frog" gets hits, the same results as "frogs". stemmer
  • determine how to handle multiple word search, auto inject OR/AND? aed4136 (do same for web search)
  • Tests #106

other back ends

TODO open new ticket for Woosh, and other backends.

NOTES

  • No FTS5 support in Python 2.7.17 (v2.7.17:c2f86d86e6, Oct 19 2019, 20:49:36) [MSC v.1500 32 bit (Intel)] on win32
    • available_pragmas = [(u'COMPILER=msvc-1500',), (u'THREADSAFE=1',)]