Backups & Migrations

Friends don’t let friends edit production tables raw.

▶ the lesson · ~35s · narrated · tap for sound

the intro

Two disciplines keep databases safe over time. Backups: copies of your data you can actually restore, tested regularly. Migrations: versioned changes to the schema that are reviewed and applied in order. Together they make change safe.

fun fact ✦

The backup rule: an untested backup is not a backup, it is a hope.

the docs

quick hits about Backups & Migrations

15-second answers · interviews, tips, trivia & hidden gems

🎤 interview

What is ACID?

📚 tutorial

Never hand-edit a prod schema

🔧 useful

Rehearse on a copy

💎 deep

The one-liner that saves careers

💎 deep

An untested backup is a hope