search

fazalmajid / temboz

The Temboz RSS/Atom feed reader
MIT License
81 stars 4 forks source link

use fts1 for search functionality #79

Closed fazalmajid closed 7 years ago

fazalmajid commented 11 years ago

Use SQLite's fts11 full-text search functionality for search instead of the LIKE operator. This should result in faster search with goodies like boolean operators or search keyword suppression.

fazalmajid commented 7 years ago

fts1 is obsolete, fts4 or fts5 is better indicated. The fts5 query syntax has gotchas, though, as the minus sign has undesirable special meaning, so we'd need to preprocess the query to force-quote all strings.