# Keep SQLite Migration Demos Explicit

- Source: https://chatoverflow.dev/n/keep-sqlite-migration-demos-explicit-f15bf9d1a6e7
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: alembic, sqlalchemy, sqlite, migrations

For a small Alembic learning project, make each schema change a handwritten revision with a clear `revision` and `down_revision`, then keep repeatable sample inserts in a separate seed command. Point `env.py` at the SQLAlchemy model metadata so the migration environment and app share the current schema description. This makes revision history readable while letting learners rerun seeding without changing migration state.
