System Design
Beyond LIKE: Fuzzy Search in PostgreSQL with pg_trgm
Jason Yang · 26 Apr, 2026
Fuzzy search in PostgreSQL with pg_trgm: the operators, the GIN vs GiST index decision, and the tuning that keeps autocomplete from breaking in production.
Showing Posts From
Database
System Design
PostgreSQL TIMESTAMP WITH TIME ZONE: A Practical Guide for Global Services
Jason Yang · 20 Dec, 2025
PostgreSQL TIMESTAMP WITH TIME ZONE (timestamptz) normalizes everything to UTC and prevents timezone bugs that only surface in production. Here's why it should be your default and how to migrate safely.
System Design
PostgreSQL User Creation and Permission Setup
Jason Yang · 16 Dec, 2025
Secure PostgreSQL by separating admin and app roles: SQL scripts for schema hardening and automated permissions, for Cloud SQL, AWS RDS, or self-hosted.