Show HN: pg_savior: a seatbelt for Postgres – blocks accidental DELETE/UPDATE

Category: database

Tags: postgresql, database-safety, extension

Score: 6.8/10 (Innovation: 6, Technical: 7, Documentation: 7, Utility: 7)

pg_savior is a PostgreSQL extension that hooks into the query parser and executor to block destructive operations (like DELETE/UPDATE without WHERE, or dangerous DDL on large tables) unless explicitly bypassed. It addresses a real pain point for production database safety with a well-architected, configurable approach using PostgreSQL's hook system.

Target audience: backend devs, devops

Repository: https://github.com/viggy28/pg_savior · C · MIT · 40 stars

View on Hacker News