Indexing Archives

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

Soft Delete Pattern in Database: Safe Record Deletion, Recovery, and Index Optimization with PostgreSQL and MySQL

May 21, 2026

Soft delete pattern lets you mark records as deleted instead of physically removing them — enabling safe recovery, audit trails, and GDPR-compliant data retention. This guide covers practical implementation in PostgreSQL and MySQL, including partial indexes, unique constraint handling, and cleanup strategies.

Database

Mastering SQL Query Optimization: A Hands-On Guide to Enhancing Database Performance

March 11, 2026

Is your application crawling? Learn to debug and fix slow SQL queries in MySQL and PostgreSQL. This hands-on guide covers EXPLAIN, strategic indexing, and smart query rewriting, ultimately enhancing your database's performance. Keep your applications fast and users satisfied.