Alembic Introduction - Migrations and Auto-Generating Revisions from SQLAlchemy Models

This video introduces Alembic, which is a migration package in Python for managing changes to your databases.

We'll look at how to setup a Migration Environment and define revisions with upgrade and downgrade operations. We'll also look at how to integrate Alembic with SQLAlchemy models, and how to use this to autogenerate revisions.

☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲:
To support the channel and encourage new videos, please consider buying me a coffee here:

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
01:01 Setting up PostgreSQL database container (Docker)
04:09 Installing Alembic
04:43 Creating Alembic Migration Environment
06:40 Connecting Alembic to Database with Connection String
07:49 Creating revision with alembic revision command
16:47 Alembic history, downgrades and relative migrations
20:07 Autogenerating migrations from SQLAlchemy Model Classes

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:

📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻:

#python #webdevelopment

[rje]

BugBytes is first tier content on youtube. Love your content on FastAPI, Alpine and HTMX !

[michaelmaguire]

Just found your channel and am very impressed by the content and quality. Thank you for putting this together and presenting it so clearly.

[mohitjoshi]

Thanks for this beautiful and easy explanation. I wish you more subscribers. Keep posting videos like these.

[tejas]

Crisp and informative. Exactly what i was looking for

[rembautimes]

Great content, watching this from Malaysia. Well documented steps to help us get started with Alembic 😀

[srikanthrenatla]

Thanks for the video. You are a very good teacher. Keep it up, bro.

[laurenssandt]

Great tutorial works with an instant adaptation to sqlmodel. Thanks

[spatialnasir]

Wonderful explanation. I can't thank you enough.

[infernape]

great video! looking forward to the alembic + fastapi video

[iwswordpress]

As ever, excellent video and presentation.

[KavinduFernando-pe]

great video super useful and highly recommended 🔥🔥

[stimpypzo]

Thanks for the brief explanation, the basic was really covered. Maybe add an example of using environment variables to use in the "sqlalchemy.url" parameter or explain the default and server_default use case, but is just too mucho info. Again, thanks!

[Marius]

Awesome shit brother, I was about to throw my laptop out the fucking window and then you perfectly described the solution to my neanderthal brain! 10/10 Amazing video 🤌🏼

[theintjengineer]

The algorithm must be messing up with you. How come you don't have 500k subscribers yet?

Anyway. Again, very high-quality content, BugBytes🎉🤯.
Thank you very much.

Greetings from Germany.

[SaiKrishnaKuchimanchi]

in my case the upgrade and downgrade functions are not getting updated. only the database is getting updated. can u tell me how to resolve this ?

[diwakardayalan]

If I need to add multiple tables, how does alembic handles it

[aashayamballi]

Can you please create video on advanced topics on Django migrations?

Thank you for the quality content!

[MrznMkhl]

can you please cover foreign keys too?

[SilverBaet]

Hi, my models are not detected when I do alembic revision initial migration

[shahidkhan]

can we use this with sqlmodel in fastapi