When building a FastAPI project with PostgreSQL, you need a reliable way to manage your database schema over time. As your application evolves, simple table creation is not enough. You need a way to safely apply, track, and roll back changes.
Alembic provides a structured, version-controlled approach to database migrations. In this guide, weโll walk through how to set up Alembic with FastAPI, SQLModel, and PostgreSQL, including common issues youโll run into when working with Docker.
In this video, Alex presents an introduction to data science “big ideas” relevant to the model, an explanation of its data modeling process, and a demonstration of the real-life machine learning solution implemented with Python, Postgres SQL, and H2O (an open-source machine learning algorithm). Multiple data sources and technologies were combined to create an accurate model that allows farmers and recreationists to make actionable insights about the future. A few questions and answers round out the discussion.
Every long-term project will outlive at least some of the technologies it was originally built with. For example, a project I have been involved with recently ran into this situation. The app is hosted on Heroku, and over the years, the available MongoDB add-ons have changed and dwindled until now, there is only one.
Several migrations between MongoDB add-ons have already happened because of shutdowns. So, it was decided that rather than migrating to the last one still in existence, the project would switch to using PostgreSQL, which is supported directly by the Heroku team.