pglifecycle 2.0 beta released as Rust rewrite
Key Takeaway
pglifecycle is an open source PostgreSQL schema management tool that uses structured YAML for version control.
Summary
The beta release of pglifecycle 2.0 introduces a complete rewrite of the tool in Rust. This schema management utility allows users to manage PostgreSQL objects like tables, views, and functions as individual YAML files in version control. It supports pulling existing databases into projects, generating DDL for reconciliation, and integrating with CI via a GitHub Action.
Technical features of pglifecycle 2.0
- Rust rewrite: The core engine has been rewritten in Rust for version 2.0.
- YAML-based schema: Stores database objects (tables, views, functions, roles) as structured YAML files.
- Drift detection: Can compare a live database against a schema project to generate reconciliation DDL.
- Safety-first deployment: Destructive changes are withheld by default unless explicitly permitted.
- CI integration: Includes a GitHub Action to detect schema drift and post deployment plans to pull requests.
Why it matters
By moving away from long migration histories toward a structured YAML state, pglifecycle aims to simplify schema reviews and deployment safety for PostgreSQL users.
Original reference: www.postgresql.org →