FastAPI & Alembic - Database Migrations in FastAPI apps

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

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
00:51 Introduction to Alembic
02:48 Alembic and FastAPI setup
08:09 Generating migrations with Alembic
13:52 Picking up model changes with migrations

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

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

#python #fastapi #webdevelopment

[mahirhaque]

You're probably the best teacher I've come across so far for FastAPI content. I love how you explain the smallest things in such detail while keeping everything simple to understand and follow. Thanks for the hard work man! I'll be looking forward to exploring your channel and learning new concepts.

For an idea of an application, maybe you could do a backend for an e-commerce website like a online book store or something. You could possibly show us how authentication works as well. I see you have done some AI content but mostly with django, maybe you would do one with FastAPI (RAG applications with databases)? I hope you'll be showing us how everything comes together and the best practices used in the industry. Also your channel's name is just 😘👌

[sadeghghasemi]

Thank you so much for all the effort you put into this. Much appreciated. :))

[XesivKuSH]

Nice! That was a beautiful explanation, thank you for this

[LaichuTV]

Just finished watching the playlist, can't wait to build a project from just learned! Thank you so much :)

[ayushshende]

Really helpful series, future topics to include, websockets, background tasks with celery, containerization, etc

[jitvimol]

This is very comprehensive tutorial. Thanks, you earn a subscription!

[rippinsail]

Thank you so much for this Series, it covers all those important topics in a very short time! I think you are actually the most time efficient youtube channel I have ever watched so far.

Regarding application ideas: what I think would be great is a very basic data analysis tool (maybe some ai features) with frontend (maybe nuxt/vue) backend communication and having the fastapi application structured with routers, schemas and crud operations as it would be in a bigger application. Maybe also point out when SQLAlchemy is better to use than SQLModel.

Anyway I am looking forward to your next FastAPI video :)
Thanks!!

[Andregol]

I came across with your content and it is certainly helpful. Now I was wondering if you can expand this series of videos and include an example in which you combine FastAPI with alembic to programmatically execute the migrations. I think that is a really valuable content that does not exist in this platform (as far as I can tell) and that be extremely helpful because the documentation it is somehow unclear in terms of how to put those concepts into practice. I know that there is no obvious solution for that context, and I consider that many people will benefit from that.

Thanks, and keep the great work up!

[kushalpy]

Please make this series in a next level in a way so that it will be helpful to the coming generation too.

[adsk]

Bro thank you for making this video. Please cover scaling related issues in fastapi. Also, please cover if there is a pre-built admin panel and role based access control add in for fastapi

[SiarheiAkhramenia]

'Proper migration fail' sounds gorgeous! 😂

[joeblack]

If you state the purpose first, we'll listen more attentively and you'll keep the viewers engaged for longer in the video.

[awakenwithoutcoffee]

appreciate it mate. Some worries/questions I have about using SQLModel : doesn't it go against single purpose principle to use Pydantic models for both database setup and the API-vaidation layer ? In my apps the database schemas have overlap but are very different than the validation layer (Pydantic). The benefit of SQLAlchemy ORM models is the clear seperation for Database models/schemas vs validation models. It seems alright for small apps but a terrible idea for production applications (?) . Cheers!

[harivetri]

Brother this playlist is enough for beginner who wants to learn fastapi ??

[Rafayak]

why not add the migration as part of the fastapi lifespan?

[ram_rahim_creations_officials]

It is taking too much time while creating migrations file... But empty migration is creating fine.

[alexandrodisla]

What’s the issue with alembic and sqlmodel was?

I saw it was easier with sqlalchemy

[haidersultan]

Is this the last video for this series bro?

[myaseena]

Hi, thanks for the video. Could you tell me what VSCode plugin are you using to preview SQLite db?

[MohammadDLitoo]

hello and tnx a lot...please update the course faster