Alembic

This is a detailed reference for managing database schema changes with Alembic in customer support systems. You get practical patterns for the full migration lifecycle: autogenerated versus manual migrations, handling data transformations during schema changes, and production deployment strategies. The examples focus on common support system scenarios like adding ticket priority fields and migrating status enums. Worth reading if you're past the basic tutorial phase and need to understand how to safely run migrations in production without breaking active support operations. The data migration section alone will save you from common pitfalls when you need to backfill or transform existing records.