3 ms·
Interesting approach, thanks for sharing! If I understood correctly, a user query is first applied to the `SearchItem` table (using the `search_vector` field?)
by polyrand 4y ago
Interesting approach, thanks for sharing!
If I understood correctly, a user query is first applied to the `SearchItem` table (using the `search_vector` field?). Then the returned `filters` are used to generate a normal (not full-text search) SQL query that would retrieve items from the product table?
- danpalmer 4y agoThat's correct! The second step therefore doesn't have any "fuzziness" to it, it's a strict inclusion/exclusion filter across products based on their attributes.