All activity
pgfence is a source-available CLI that catches dangerous Postgres migrations in your CI/CD pipeline. Unlike existing tools in Ruby or Go, it is natively built for the Node.js ecosystem (Prisma, TypeORM, Drizzle, Sequelize). It analyzes DDL to predict precise locking behaviors (like ACCESS EXCLUSIVE), flags risks, and generates the exact zero-downtime rewrite recipes you need. Stop shipping DB downtime masked as harmless schema changes.
pgfenceStop dangerous Postgres migrations before hitting production
Munteanu Flavius-Ioanleft a comment
Hi Product Hunt! I'm Flavius, the maker of pgfence. I built pgfence after witnessing too many "routine" database migrations take down production apps. A seemingly harmless line like `ALTER TABLE users ADD COLUMN is_verified BOOLEAN NOT NULL DEFAULT false` takes an `ACCESS EXCLUSIVE` lock. It queues behind your longest-running query, and while it waits, every incoming connection cascades behind...
pgfenceStop dangerous Postgres migrations before hitting production