pgfence
Stop dangerous Postgres migrations before hitting production
What it does
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.
Does the same job
all alternatives →- PSPgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲326
Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…
- ZDZero-downtime PostgreSQL migrations for Ruby on Rails2022 · github.com · ▲36
- PNpg_netstat, a Postgres extension to monitor database network traffic2022 · github.com · ▲158
pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.
- PSPgDog – Shard Postgres without extensions2025 · github.com · ▲307
Hey HN! Lev here, author of PgDog (https://github.com/pgdogdev/pgdog). I’m scaling our favorite database, PostgreSQL. PgDog is a new open source proxy, written in Rust, with first-class support for sharding — without changes to your app or needing database extensions. Here’s a walkthrough of how it works: https://www.youtube.com/watch?v=y6sebczWZ-c Running Postgres at scale is hard. Eventually, one primary isn’t enough at which point you need to split it up. Since there is currently no good tooling out there to do this, teams end up breaking their apps…
More dev tools this month
the category →
The first open-source price index for GPU compute
Dev tools · 10d ago · getcomputable.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
