Explain SQLAlchemy ORM vs Pydantic models in FastAPI
This tests separation of database schema from API contracts. A strong answer distinguishes SQLAlchemy table rows from Pydantic validation and OpenAPI generation, and notes that create schemas exclude auto-generated IDs.
This tests architectural separation between persistence and the API surface. A strong answer explains that SQLAlchemy ORM models define tables, relationships, and session state, while Pydantic models enforce JSON shape and generate OpenAPI docs. It notes that a create schema omits server-generated fields like IDs so clients cannot set them. A red flag is using the ORM model as a request body or arguing duplication alone justifies merging layers.
Read the original → fastapi.tiangolo.com
- #python
- #fastapi
- #sqlalchemy
- #pydantic
- #api-design
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.