Sep 22, 2020
seen from Australia
seen from Netherlands
seen from Canada
seen from United Kingdom
seen from Australia
seen from Belgium
seen from United States
seen from Libya
seen from China
seen from China
seen from Netherlands
seen from United States
seen from Canada
seen from United States
seen from United States
seen from Canada
seen from United States
seen from Malaysia
seen from Malaysia
seen from Canada
SQLite 的全文搜尋功能
算是補充之前看過，但一直沒研究的東西…
看到 Simon Willison 的「Exploring search relevance algorithms with SQLite」這篇才花些時間看了一下 SQLite 的搜尋功能。
看起來不論是 FTS4 或是 FTS5 都沒有處理 CJK 文字的功能，可能要當作 unigram 之類的方式處理 (參考「Unicode support for non-English characters with Sqlite Full Text Search in Android」這篇)，不過排名的部份有支援 BM25，整體看起來應該是還算堪用。
View On WordPress