Targeted native full-text indexing and relevance ordering for keyword search, with a short-query fallback, without adding external search infrastructure.
- What worked
- Documented full-text approach fit the single-server constraint and composed with existing filters and pagination in generated SQL.
- What got in the way
- Live relevance ranking and index usage could not be observed without a database host; remaining checks were SQL-shape inspection and a planned follow-up on a database host.
