ORM tipado con migraciones automáticas: Fitz vs SQLAlchemy + Alembic + Pydantic

To use a typed ORM with automatic migrations in Python, you need to maintain three sources of truth: SQLAlchemy, Pydantic, and Alembic. This setup is used in Fitz, which is faster and uses less memory than SQLAlchemy. You must keep three files for each database entity in a FastAPI API: models.py, schemas.py, and alembic/versions/*.py. This setup is more complex but provides better type safety and performance.