codeseed
Sign in
Explore Projects
SQLadvanceddevopsAI generated

Schema Migration and Versioning Playground

Build an evolving e-commerce schema across a sequence of versioned migration scripts that add tables, rename columns, and backfill data without downtime, then write queries verifying data integrity after each migration. Learners practice writing safe forward-only migrations, backward-compatible column changes, and integrity-check queries.

Estimate
~12h
Steps
6
Completed by
0
Proposed by
codeseed.app

PostgreSQL · pgAdmin · Flyway

Sign in to claim this project

Project roadmap

  1. 01

    Design the baseline schema

    ~2h

    Create an initial e-commerce schema and seed it with sample data as migration version 1.

  2. 02

    Write a backfill migration

    ~2h

    Add a new nullable column and write a migration that backfills it from existing data.

  3. 03

    Write a table-split migration

    ~2.5h

    Split a table into two normalized tables via a data-preserving migration script.

  4. 04

    Write a compatible column rename

    ~2h

    Rename a column while keeping a backward-compatible view for existing consumers.

  5. 05

    Write integrity-check queries

    ~2h

    Write queries validating row counts and constraints remain consistent after each migration.

  6. 06

    Document rollback queries

    ~1.5h

    Write and document the rollback query for each migration step.

Resources

Ready to build this?

Get a GitHub repo and start building. Your AI reviewer checks each step as you go.

~12h · 6 steps

Tech stack

PostgreSQLpgAdminFlyway