SQLModel – SQL Databases in FastAPI

Re:SQLModel – SQL Databases in FastAPI by tedmiston on Tuesday August 24, 2021 @10:56PM (#28297569)

Thank you for building this! So I'm running a FastAPI deployment in prod already today using both Pydantic models for the app / API itself and also reflected SQLAlchemy ORM models for the database. In my case I am lucky in that my app interacts (read only) with a data warehouse as opposed to a schema that it manages directly.

Am I understanding right that the main benefit of using sqlmodel is not needing to maintain the 2 separate models for the app vs db that one would need in most cases?

Also, have you thought about an approach to migrations yet? Curious to hear your thoughts there as well.

[ Parent | on HN ]

Re:SQLModel – SQL Databases in FastAPI by tiangolo on Wednesday August 25, 2021 @06:34AM (#28299880)

Yep, less code duplication between Pydantic and SQLAlchemy, autocompletion and inline errors in editors (e.g. when creating new instances and when fetching data from the database), because it has several type annotation tricks.

It's all just SQLAlchemy, so the same migrations with Alembic would do it, I plan on documenting that in the future and probably adding a thin layer on top.

[ Parent | on HN ]