Database schema management for lazybones: from chaos to heaven

intro_logo

SCALE 21x

Julien RIOU

March 15, 2024

Speaker

Summary

  1. Basics of schema migrations
  2. Who are we?
  3. Chaos
  4. Schema as code, CI/CD, code reviews
  5. Inventory, automation
  6. Heaven
  7. Known issues
  8. Takeaways

Basics of schema migrations

Schema

Schema changes over time

  • New tables
  • New columns
  • New constraints
  • New everything

Schema migration

Data definition language (DDL)

ALTER TABLE customer
    ADD COLUMN archived_at TIMESTAMP WITH TIME ZONE;

Who are we?

Internal databases