Extra Credit

Alembic

Official docs outline

13 sections
  1. Tutorial

    Creating an environment, writing and running migrations, revisions, and upgrade/downgrade.

  2. Auto generating migrations

    Comparing model metadata to the database to generate migration scripts, and its limitations.

  3. Operation reference

    Operations such as create_table, add_column, alter_column and execute available in migrations.

  4. Working with branches

    Branching, merging, heads and branch labels for parallel development.

  5. Generating SQL scripts (offline mode)

    Producing SQL output instead of connecting to the database.

  6. Running batch migrations for SQLite

    Move-and-copy table recreation for databases with limited ALTER support.

  7. Naming constraints

    Using naming conventions so constraints can be altered and dropped reliably.

  8. Cookbook

    Recipes for multi-database, environment variables, replaceable objects and conditional migrations.

  9. The migration environment (env.py)

    Runtime API of MigrationContext, EnvironmentContext and customizing env.py.

  10. Configuration

    alembic.ini options, file templates, script location and logging.

  11. Commands

    The command API for revision, upgrade, downgrade, stamp, history and current.

  12. Multiple version directories

    Using multiple base revisions or separate version locations.

  13. Front matter and architecture

    Alembic's relationship to SQLAlchemy, supported databases and dependencies.

Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.

All 113