Full-Text Search
Full-text search finds documents matching natural-language queries by indexing words and their variants, ranking results by relevance rather than exact matching.
Unlike a simple LIKE query, full-text search understands word boundaries, stemming (matching 'run' and 'running'), and relevance ranking. It's how search boxes return useful results quickly over large text columns.
The database has built-in full-text search using tsvector and tsquery types and GIN indexes, so you can add search to your data without a separate search service for many workloads.
For very search-heavy products, a dedicated search engine may be warranted, but Built-in full-text search covers a wide range of needs with no extra infrastructure.
Related terms
Full-Text Search in basefyio
See it in practice
basefyio gives you database, auth, storage, and a REST API in minutes.