AI Generated Migration Works on Dev, Fails on Prod Schema
AI-written migration runs clean on an empty dev DB but blows up on prod with constraint or data errors. Fix with dev-prod parity and safety checks.
#Database
Articles tagged with #Database
AI-Generated SQL Locks a Hot Table for Minutes
AI wrote a query or update that holds long locks on a production table, blocking reads and writes. Identify the pattern and rewrite it to be lock-friendly.
Postgres Autovacuum Stalled by a Long-Running Transaction
Table bloat grows, queries get slower, and pg_stat_progress_vacuum shows nothing running. A single forgotten transaction is holding back the entire vacuum horizon.
Database Migration Review Prompts for Safe Schema Changes
Migration review prompts that catch lock-table-for-an-hour bugs, backfill races, and silent column drops. 12 templates for Postgres / MySQL / SQLite reviews.