Database Migrations in Production

Running database schema migrations safely in production requires isolating schema DDL operations from the application container lifecycle.

Safe Migration Workflow

Pre-Deployment Check: Test migration scripts in a staging environment matching production TimescaleDB versions:
```
alembic current
alembic heads
```
Execute Migrations Before Code Rollout: Trigger the one-shot migration profile container:
```
docker compose --profile migrate run --rm fonrex-migrate
```
Deploy New API Containers: Once alembic upgrade head finishes successfully, update your API application image:
```
docker compose up -d fonrex-api
```

Rollback Strategy: If a migration fails, revert to the previous migration revision:

docker compose --profile migrate run --rm fonrex-migrate alembic downgrade -1