跳过 Elasticsearch：在 Supabase 中构建快速的全文本搜索
1 分•作者: ReclusiveCoder•8 个月前
许多开发者在搜索时会默认选择 Elasticsearch 或 Solr——但对于中小型应用程序来说，这通常是过度配置。Postgres 内置全文搜索功能已经很多年了，并且通过 Supabase，你可以直接用 SQL 查询它。<p>我写了一篇简短的指南，展示了如何设置它，并在无需额外基础设施的情况下获得极速搜索：<p>https://dev.to/reclusivecoder/skip-elasticsearch-build-blazing-fast-full-text-search-right-in-supabase-58pf<p>很想知道其他人是否在生产环境中使用 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://dev.to/reclusivecoder/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/scale you'd rather switch to Elasticsearch.