Getting search results back is easy; getting the right products in the right order is the real work. A deep-dive on relevance tuning for a store — boosting by business signals, synonyms, typo handling, zero-results, and measuring whether your changes actually help.
When a store needs search, the reflex is Elasticsearch — but Postgres full-text search has grown up. A head-to-head for the e-commerce case: ranking, facets, typo tolerance, and the operational cost that decides it.
SQL LIKE is not search. A deep-dive on adding real full-text search to a Rails app with Elasticsearch — analyzers, mappings, relevance, keeping the index in sync — and an honest take on when Postgres is enough instead.