Full-Text Search Archives

Deploying OpenSearch on Docker: A Guide to Full-Text Search and Log Analytics

July 19, 2026

Ditch slow SQL queries. This guide shows you how to set up OpenSearch and Dashboards using Docker for high-performance full-text search and log analytics.

Database

PostgreSQL pg_trgm: Build Fuzzy Search, Typo-Tolerant Queries, and Autocomplete with Trigram Indexes

June 28, 2026

Learn how to use PostgreSQL's pg_trgm extension to build fuzzy search that handles typos, powers autocomplete, and accelerates LIKE queries with trigram indexes. Includes practical GIN index setup, similarity threshold tuning, and hybrid search patterns.

Database

Stop Over-Engineering: High-Performance PostgreSQL Search without Elasticsearch

April 20, 2026

Is Elasticsearch overkill for your app? Learn how we achieved sub-100ms search on 1.2M rows using PostgreSQL's native GIN indexes and tsvector.