1 Repo
Populates new columns by running batch UPDATE operations directly on the table while triggers maintain consistency.
Distinct from Column Population: Distinct from Column Population: focuses on backfilling columns during schema migrations with trigger-based synchronization, not general column population from iterators.
Explore 1 awesome GitHub repository matching data & databases · Trigger-Based 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
Provides automated column backfill using batch updates and trigger-based synchronization during schema migrations.