1 repository
Filling new columns from existing data during a migration and keeping them synchronized via triggers until completion.
Distinct from Data Backfilling: Distinct from Data Backfilling: focuses on trigger-synchronized backfill during schema migrations, not general missing value population.
Explore 1 awesome GitHub repository matching data & databases · Trigger-Synced Column Backfills. 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
Fills new columns from existing data and keeps them synchronized via triggers during migrations.