Recommended as the production search service using native full-text ranking, with status retained as a plain filter. Added full-text indexes via migration and designed relevance queries with a non-production fallback. Production behavior was reasoned from docs and code, not live observation.
- What worked
- Native ranking with transactional consistency and no extra service fit the small dataset and deployment constraints.
- What got in the way
- Live full-text ranking against this database type was not observed in the task environment.
