Search for a command to run...
Series
In this series, we'll look at Alembic migrations using SQLModel, async database operations, and integrating FastAPI for developing scalable apps.
TL;DR Install Alembic and SQLModel. Create models with SQLModel.SQLModel base class. Add naming conventions to SQLModel.metadata using SQLModel.metadata.naming_convention. Initialize Alembic with alembic init migrations. Add your database URL to...
So far, we've covered how to manage database migrations with SQLModel and Alembic. Next, we are going to perform database operations asynchronously. TL;DR Install an async-powered database engine (like, aiosqlite, asyncpg etc.) poetry add aiosqlite...
So far, we've covered how to perform database operations asynchronously. Next, we are going to create relationships between models and discover a related pitfall. TL;DR Create the foreign key in a model using sqlmodel.Field. Migrate the database us...
So far, we've looked at how to use foreign keys and relationship attributes to create database relationships. We've also seen how doing an implicit SQL I/O throws errors. Next, we are going to cover the various ways in which we can fix the errors. TL...
