{"library":"pg-patcher","type":"library","category":null,"description":"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.","language":"javascript","status":"maintenance","version":"0.5.2","tags":["javascript","pg","postgres","postgresql","patch","patcher","node-postgres"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install pg-patcher","imports":["import pgpatcher from 'pg-patcher'","const pgpatcher = require('pg-patcher')","npx pg-patcher --host localhost --database mydb --user myuser --level 2"]},{"cmd":"yarn add pg-patcher","imports":[]},{"cmd":"pnpm add pg-patcher","imports":[]}],"homepage":"https://github.com/chilts/pg-patcher/","github":"https://github.com/chilts/pg-patcher","docs":null,"changelog":null,"pypi":null,"npm":"pg-patcher","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}