Why I Use Partial Indexes for “Active Jobs” in Postgres
Keeping 50ms p95 while 8,000+ listings churn daily
Apr 7, 20266 min read
Command Palette
Search for a command to run...
#systemdesign
Articles tagged with #systemdesign
Why I Add an Outbox Table Instead of “Just Using a Queue”
A decision framework for reliable events in Postgres-backed systems
Feb 24, 20268 min read3Why I Use Canonical + noindex as an SEO Safety Net
A pragmatic way to prevent duplicate URLs from poisoning indexing
Feb 5, 20267 min read2Why I Add an Async Outbox Before Reaching for Kafka
A solo-dev pattern for reliable emails and webhooks without a message bus
Jan 29, 20269 min read11Why I Use pg_trgm Fuzzy Search Instead of Full-Text Search
Production notes from a 7,556-job board with fast, typo-tolerant filters
Jan 27, 20268 min read