{"library":"postgres-migrations","type":"library","category":null,"description":"The `postgres-migrations` package provides a robust database migration solution for PostgreSQL, directly inspired by Stack Overflow's deployment methodology. Currently at version 5.3.0, it offers a stable and opinionated approach to managing database schema changes. Key differentiators include its strict sequential SQL file-based ordering, which explicitly avoids timestamp-based naming to ensure consistent execution order across all environments. The library deliberately eschews 'down' migrations, advocating for a 'roll forward' philosophy where issues are addressed by applying new incremental migrations. It enforces database integrity by performing hash checks on previously applied migration files, preventing accidental or unauthorized modifications. The package maintains a hidden `migrations` table to track applied scripts and requires Node.js 10.17.0+ and PostgreSQL 9.4+.","language":"javascript","status":"active","version":"5.3.0","tags":["javascript","postgres","postgresql","migration","migrations","sql","database","db","typescript"],"install":[{"cmd":"npm install postgres-migrations","imports":["import { migrate } from 'postgres-migrations'","import { loadMigrationFiles } from 'postgres-migrations'","import { Client } from 'pg'"]},{"cmd":"yarn add postgres-migrations","imports":[]},{"cmd":"pnpm add postgres-migrations","imports":[]}],"homepage":null,"github":"https://github.com/thomwright/postgres-migrations","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/postgres-migrations","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"18–22","success_rate":0,"avg_install_s":null,"avg_import_s":null,"wheel_type":null},"url":"https://checklist.day/v1/registry/postgres-migrations/compatibility"},"provenance":{"verified_status":null,"verified_at":null,"last_verified":"Wed Jun 17","next_check":"Tue Jul 21","install_tag":null}}