Write a Reversible Migration

A migration that cannot be undone is a migration you cannot deploy on a Friday. Write the change and the way back.

Validator

⏱ 0:00

IDLE — checks run live as you type commands; submit when done

01Requirements

live checks

Directory ~/backend/db/migrations exists○
File ~/backend/db/migrations/001_create_orders.sql exists and creates the table○
File ~/backend/db/migrations/001_create_orders.down.sql exists and drops it○

1 of 5 revealed

01
Create the migrations directory
Migrations are numbered in the order they run - the file name is the version.
mkdir -p ~/backend/db/migrations
4 locked · each failed submit reveals one

0 of 3 revealed

Take a hint without losing the lab — each one points at the thing to look at, not at the answer.

guides, never solves

Tell me what you're stuck on — I'll nudge, not solve. Which requirement are you looking at?

saved locally in this browser

learner@lab — ubuntu:24.04

Session is disposable

↑/↓ recalls commands · Ctrl+Enter submits · type help for the command list

← Previous lab

Index the Queries You Run

Relational Databases

Next lab →

Pick the Right Isolation Level

Relational Databases