Many developers default to Elasticsearch or Solr for search—but for small to medium apps, that’s often overkill. Postgres has had full-text search built in for years, and with Supabase you can query it directly in SQL.

I wrote a short guide showing how to set it up and get blazing-fast search without extra infrastructure:

https://dev.to/reclusivecoder/skip-elasticsearch-build-blazing-fast-full-text-search-right-in-supabase-58pf

Would love to hear if others are using Postgres full-text search in production, and at what point/scale you'd rather switch to Elasticsearch.