Skip to main content

Database & Migrations

BlitzShip uses Flask‑Migrate (Alembic) to manage your schema.

Local (SQLite)​

By default in Dev:

flask db upgrade

This creates instance/database.db.

Production (Postgres)​

On Prod:

  1. Provision a database (Heroku Postgres, RDS, etc.).
  2. Ensure DATABASE_URL is set in your environment.
  3. Run: 
    flask db upgrade

Commands​

  • flask db init ‑ only if you need a fresh migrations folder
  • flask db migrate -m "Message" ‑ auto‑generate a new revision
  • flask db upgrade ‑ apply revisions