Learn

Deep dive into search concepts, and learn how to build powerful search features in Postgres.

Introduction to Tantivy, a fast full-text search engine library written in Rust

Learn about faceting and faceted search, how they relate to aggregations, and when to use them.

Learn about retrieval-Augmented Generation (RAG) and how it uses search to increase LLM effectiveness

Learn how to implement powerful text search directly in PostgreSQL using built-in full-text search capabilities.

Learn how to implement BM25 ranking in PostgreSQL using various approaches from SQL to ParadeDB extensions.

Learn about full-text search capabilities, how they work, and when to use them in your applications.

Learn about hybrid search systems that combine lexical and semantic search for comprehensive results.

Learn about Reciprocal Rank Fusion (RRF), a technique for combining multiple search result rankings.

Learn about vector search, how it enables semantic similarity matching using high-dimensional embeddings.

Learn about BM25, the ranking algorithm that powers modern search engines.