2 ms·
I don't know the exact syntax any more, but I expect this could be solved by a single sql query that uses "inexact but close" queries and a bunch of indexes (an
by otikik 2mo ago
I don't know the exact syntax any more, but I expect this could be solved by a single sql query that uses "inexact but close" queries and a bunch of indexes (and perhaps tags) on each category.
- Terr_ 2mo agoLike some sort of Jaccard Index based on how many tags are shared? https://en.wikipedia.org/wiki/Jaccard_index https://en.wikipedia.org/wiki/Jaccard_index
- otikik 2mo agoI was thinking more along the lines of using text search [1] [2] [1] https://www.postgresql.org/docs/current/textsearch-intro.html https://www.postgresql.org/docs/current/textsearch-intro.htm... [2] https://www.elastic.co/docs/explore-analyze/query-filter https://www.elastic.co/docs/explore-analyze/query-filter