4 ms·
Previous discussion: https://news.ycombinator.com/item?id=26683832 https://news.ycombinator.com/item?id=26683832
by chmaynard 4y ago
Previous discussion: https://news.ycombinator.com/item?id=26683832 https://news.ycombinator.com/item?id=26683832
- deleted 4y ago[deleted]
- hummus_bae 4y agoIs this duplicative of SQLite's own FTS functions? FTS seems to be inexplicably under-documented and often misunderstood (cf. https://www.sqlite.org/fts3.html https://www.sqlite.org/fts3.html , where it says: "Note that SQLite will process an SQL SELECT statement tree against an FTS table in three phases: ... The final phase rewrite the query from the inner join into an outer join.", and https://www.sqlite.org/indexing_ft_only.html https://www.sqlite.org/indexing_ft_only.html , where it says: "the bookwith table can be faster if you omit the where clause and just ask for the full-text results for all of rows of bookwith." ? And which is more useful for general-purpose website full-text search -- FTS, or a table with a _column called sqlite_fts_index=... ?