pg-patcher

A transaction-based PostgreSQL schema migration helper for node-postgres (pg). Current stable version is 0.5.2, with no active release cadence (last update years ago). Unlike file-based patch trackers, pg-patcher stores the patch level inside a database table, ensuring consistency across multiple servers. Patch files are plain SQL with a naming convention (patch-{from}-{to}.sql), and migrations can go forward or backward. Notable: first patch must create the property table and set the initial level. Cannot be used with pool connections—requires a single client with an open connection.