1 repository
Creates a stable view layer that abstracts schema changes, allowing clients to query either the old or new version by name.
Distinct from Version View Refreshing: Distinct from Version View Refreshing: focuses on creating versioned views for schema migration, not refreshing a reader's view pointer.
Explore 1 awesome GitHub repository matching data & databases · Schema Version Views. Refine with filters or upvote what's useful.
pgroll is a PostgreSQL migration framework designed for zero-downtime schema changes. It applies non-blocking DDL operations that avoid exclusive locks on tables, and uses trigger-based column backfill to populate new columns while keeping them synchronized with old ones. The framework wraps each migration step in a database transaction that can be atomically committed or rolled back, and creates a versioned view layer that exposes both old and new schema versions simultaneously to client applications. The tool distinguishes itself by managing multiple schema versions via views, enabling safe
Creates a stable view layer that abstracts schema changes for querying old or new versions by name.