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.
Comments URL: https://news.ycombinator.com/item?id=45459475
Points: 2
# Comments: 0
Source: news.ycombinator.com
