Tag archive
One ALTER TABLE RENAME COLUMN breaks a rolling deploy. Run the safe Postgres version: add, sync with a trigger, backfill in batches, switch, drop.
PostgreSQL EXPLAIN ANALYZE: What I Actually Look At in Query Plans Every slow query I have...
PostgreSQL 19 Slips to November as AI Code Review Finds Bugs Faster Than Humans Can Fix...
Postgres "deadlock detected" (40P01): read the error, fix lock ordering with ORDER BY ... FOR UPDATE, and add a retry as the safety net.
Introduction: The Headline That Made My Stomach Drop Almost every week, we see another...
A database test in our suite failed about one run in eight. Here is the full path from symptom to...
Because I liked asks what you loved and why, then finds films, shows, books and games that match the...
Most open-source RAG tools I tried had the same gap. Either org-level access control sat behind a...
prisma migrate dev hanging on Supabase? PgBouncer transaction mode kills the migration lock. The directUrl fix + a URL-per-command matrix.
A few months ago I set myself a goal that, looking back, sounded like technical suicide: fitting an...
Stop testing RLS on production. Use Neon copy-on-write branches + the two-user isolation test, then promote only when green.
The most common Supabase leak isn't RLS off - it's policies that pass every linter yet expose data. 3 bug classes, detection SQL, and fixes.