跳过Elasticsearch:在Supabase中快速构建全文搜索

1作者: ReclusiveCoder大约 1 个月前原帖
许多开发者默认选择 Elasticsearch 或 Solr 作为搜索解决方案,但对于小型到中型应用来说,这往往是过于复杂的选择。Postgres 多年来一直内置了全文搜索功能,而通过 Supabase,你可以直接使用 SQL 查询它。 我写了一篇简短的指南,展示如何设置并在没有额外基础设施的情况下实现快速的搜索体验: https://dev.to/reclusivecoder/skip-elasticsearch-build-blazing-fast-full-text-search-right-in-supabase-58pf 我很想知道其他人是否在生产环境中使用 Postgres 的全文搜索,以及在什么情况下/规模下你们会考虑切换到 Elasticsearch。
查看原文
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.<p>I wrote a short guide showing how to set it up and get blazing-fast search without extra infrastructure:<p>https:&#x2F;&#x2F;dev.to&#x2F;reclusivecoder&#x2F;skip-elasticsearch-build-blazing-fast-full-text-search-right-in-supabase-58pf<p>Would love to hear if others are using Postgres full-text search in production, and at what point&#x2F;scale you&#x27;d rather switch to Elasticsearch.