Migrations

9 pages in this section.

Why schema migrations are really a locking and sequencing problem more than a SQL-writing problem, and the mental model - transactional DDL, lock strength, and expand/contract - behind every migration page in this section.

Explainer Postgresql Migrations Schema Change

Migrations Basics

Learn migration fundamentals with 7 SQL examples. Understand versioned SQL in Git, schema history tables, and migration best practices.

Sql Migrations Schema Change Basics Migrations

Flyway & Liquibase

Compare Flyway and Liquibase, two JVM-based migration runners for PostgreSQL. Learn when to use each and see examples of their configuration.

Sql Migrations Schema Change Flyway Liquibase

Expand/Contract Pattern

Implement the expand/contract pattern for schema changes to rename columns, change types, or split tables without downtime.

Sql Migrations Schema Change Expand Contract

Zero-Downtime DDL

Sql Migrations Schema Change Zero Downtime

Rollback Strategy

Sql Migrations Schema Change Advanced Rollback

Large Table Migrations

Sql Migrations Schema Change Large Table

Migrations Best Practices

Learn best practices for versioned schema changes, including Git workflow, safety measures, and zero-downtime design for database migrations.

Sql Migrations Schema Change Best Practices List

Migrations Highlights Summary

A single-page roundup of every highlight bullet from the 8 pages in the Migrations section, grouped by source page so you can scan all 46 takeaways without opening each article individually.

Highlights Summary Migrations Schema Change

Migrations

Search Documentation

Migrations