Talk Python To Me #353: SQLModel: The New ORM for FastAPI and Beyond
Feb 18, 2022
Explore the synergies between PyDantic and SQL Alchemy with SQLModel for FastAPI efficiency. Discover precise type annotations for database generation and secure data handling. Dive into API performance considerations, data relationships, and future front-end developments in Python. Enhance Olympic's usability and testing with SQLModel, and discuss tools for Python development.
AI Snips
Chapters
Transcript
Episode notes
SQLModel's Purpose
- FastAPI and Pydantic are popular Python frameworks.
- SQLModel connects these with ORMs like SQLAlchemy, solving data model duplication.
Streamlining Data Models
- FastAPI and ORMs require duplicate data model definitions.
- SQLModel offers a streamlined approach, enhancing developer experience.
Pydantic and SQLModel
- Define models in Pydantic to drive FastAPI's features.
- SQLModel integrates Pydantic models with SQLAlchemy for database interaction.