C
Oct 25, 2026Code evolves quickly, databases remember everything
A common backend mistake: treating database schemas like temporary code. Code deploys in minutes....
Oct 25, 20261 min read1 reactions0 comments
Back to articles 
Oct 25, 2026
Oct 25, 2026
Oct 25, 2026
Oct 25, 2026
Tag archive
#postgres
Risky email verdicts need routing before deletion
Route catch-all email verdicts with TypeScript, quarantine schema failures, and upsert lead decisions into Postgres.
Oct 25, 20267 min read0 reactions0 comments
Sentry and Mandrill Both Went Down When Postgres Ran Out of Transaction IDs
Sentry in 2015, Mandrill in 2019: same Postgres wall, 32-bit transaction IDs near wraparound. How freezing works and the two queries to alert on.
Oct 25, 20269 min read1 reactions0 comments
W
Oct 25, 2026Why Patroni failover takes 26–49 seconds with default settings (and how to make it faster)
You build a Patroni + etcd + HAProxy cluster, kill the primary in a test, and your write loop stops...
Oct 25, 20265 min read0 reactions0 comments
Y
Oct 25, 2026Your Database Has Permissions. But Can You Prove They're Working?
Most developers focus on securing their databases. But here's a harder question: Can you actually...
Oct 25, 20261 min read0 reactions0 comments
Y
Oct 25, 2026Your PostgreSQL Database Is Secure. But Are Your Tenants?
One missing tenant filter. One overlooked authorization check. Suddenly, Customer A can access...
Oct 25, 20261 min read0 reactions0 comments
H
Oct 25, 2026How We Cut Postgres p95 Latency from 914ms to 2ms (Serverless vs. Docker + PgBouncer)
Breaking down where our 914ms p95 database latency actually went, what same-region tuning fixed (9ms), and how co-located PostgreSQL 18 + PgBouncer 1.26 brought it down to 2ms.
Oct 25, 20265 min read0 reactions0 comments
Composite Indexes in PostgreSQL & MySQL: Column Order Guide
Adding three separate single-column indexes on tenant_id, status, and created_at will not make a...
Oct 25, 20267 min read0 reactions0 comments
I
Oct 25, 2026I Built an Open-Source Rust Proxy to Strengthen PostgreSQL Tenant Isolation
I Built an Open-Source Rust Proxy to Help Prevent Cross-Tenant Data Leaks in PostgreSQL Tags:...
Oct 25, 20262 min read0 reactions0 comments
H
Oct 25, 2026How to test Supabase RLS with two accounts (10 minutes, no tools)
If user B can read user A's rows, your policies are too loose. Here's the two-account test, plus the SQL-editor way.
Oct 25, 20263 min read0 reactions0 comments
P
Oct 25, 2026PostgreSQL high availability with only 2 servers: where the third vote comes from
Many teams have budget for two database servers, not three. Almost every PostgreSQL high-availability...
Oct 25, 20265 min read0 reactions0 comments
TanStack Query, Zustand, Firebase, Redis and NeonDB: The Data Architecture Behind IdeaPilot
Lessons from building a React Native application for AI-powered project discovery, creation, and...
Oct 25, 20267 min read1 reactions1 comments