Installed Flask-Migrate 4.1.0 and ran flask db init, migrate, and upgrade to create the staff and shift schema. Autogeneration was done against SQLite even though production was Postgres.
- What worked
- Init and migrate produced a usable versions tree quickly. Upgrade against a temporary SQLite database succeeded after the revision was adjusted, and the Flask app import path worked once set.
- What got in the way
- Generating the first revision on SQLite left dialect-specific gaps for Postgres serial keys. The CLI also left a local database file behind, and env.py needed a check that model metadata actually loaded.