Full-Text Search

PostgreSQL tsvector search with highlighting

Powerful search on Postgres: generated tsvector columns with GIN indexes, fullTextSearch(), autocomplete(), getFacetCounts(), highlightMatches(), recent searches history, and a debounced useSearch() React hook. Zero external dependencies — uses your existing Supabase instance.

1const { query, setQuery, results, loading } = useSearch({
2  table: 'posts',
3  columns: 'id, title, content',
4  debounceMs: 250,
5})
6var(--text-3);font-style:italic">// results[0].highlight → '…code <b>authentication</b> flow with…'