Building a REST API with FastAPI, Async SQLModel, and PostgreSQL

[@SsaliJonathan]

Hi guys, Kindly click the like button because this video was hard to make. Please join me on my discord server here. discord.gg/jqde9VSG

[@kisamehoshigaki-u1p]

bro invite link not working for me

[@damarisscott7643]

Also did not work for me :(

[@illuminaughty666]

TBH this channel got me so much interest and motivation to learn FastAPI

[@SsaliJonathan]

Thanks for the kind comment

[@andersonlontsi299]

Thank you sir. I followed your DRF tutorial and even deployed my app , but Please i have a serious issue managing migrations production. i made some research and decided not to push my migration files anymore so that the command:"release: python manage.py migrate --no-input" in the procfile will take care of migrating everything. But i don't understand why added a field and migrations occured locally and are working fine but in production there is this error:"column main_item.price does not exist". Please sir could you make a video to explain us the best practices for handling migrations/database changes in production? I'm sure it will help more than one. i reall will be grateful 🙏🙏 It is a backend on which i'll certainly have to be doing changes from time to time and i don't want this to happen when there will be actual data in the backend( will soon release the app i'm working on). Since so far i have been resolving this problem by formating the database😔😥 It really hurts

[@codeaperture]

Much love from Kenya. Kazi safi! Had to sub. I'm loving FastAPI

[@SsaliJonathan]

I’m glad you like it. Thanks for watching

[@tomshelby3029]

It was super helpful!

[@SsaliJonathan]

Glad it was helpful!

[@NtcPedroPeterNews]

Fantastic tutorial, thank you so much!

[@SsaliJonathan]

Glad you found it useful

[@martinmiz]

Another great tutorial. Thank you very much. I would like to request for a tutorial of FastAPI with React, showing the frontend and backend usage of the API. I would also like to see how you handle storage of other data files like images in the API database.

[@SsaliJonathan]

Sure. Nice topic. I will consider making this

[@terryliu3635]

I need to try this tomorrow. been struggling with the same scenario. I was using asyncpg only to connect to the Postgres database in Docker. I do not have any problem connecting to the database from another Python file, just this "fastAPI + async + Postgres + asyncpg package" does not work for me....do you have any experience using asyncpg package...maybe could shed some light here? thanks!

[@SsaliJonathan]

a good URI could be asyncpg+postgresql://:@/

[@terryliu3635]

@@SsaliJonathan Thanks Jonathan. I switched this to the approach you mentioned in your video, I got the same error message "Connection test failed: Multiple exceptions: [Errno 111] Connect call failed ('::1', 5432, 0, 0), [Errno 111] Connect call failed ('127.0.0.1', 5432)"... PS. I'm Uvicone + Fastapi in my VS.code on Mac and Postgres in Docker on the same machine. I wonder if this is something else...because if I do not use FastAPI to call Postgres the same way, I do not have any problems getting the records successfully. Your video is still valuable to me since I know FastAPI + Async + Postgres works.

[@terryliu3635]

OMG!! based on what I learned here plus ChatGPT and Claude, it's the network, I should NOT have used localhost since both my Postgres and my Fast API are in containers!! It worked fine now! Thanks again!

[@densondube369]

Hey Jonathan, I have config.py just as you have it on your video, but settings = Setting() has Settings() underlined( error = Argument missing for parameter "DATABASE_URL"). Why?

[@densondube369]

No worries, got sorted. Was missing a 'package'

[@densondube369]

Awesome tutorial!

[@SsaliJonathan]

Glad you did!

[@SsaliJonathan]

Thanks for watching

[@deevirus6725]

How to read Excel file form storege and upload it on firestore plz make ASAP 😅

[@deevirus6725]

Reply please

[@ozoindaprince]

NA WHY WE DE CALL YOU GOAT! YOU NA BIG 7. TYSM

[@arminkessler2566]

Hi Jonathan, could you include Authentication in a next part of this serie of videos. Thanks in advance.

[@SsaliJonathan]

Great suggestion!

[@arminkessler2566]

@@SsaliJonathan Thank you Jonathan , your videos are excellent , regards Armin

[@SsaliJonathan]

Hey, the comment section is really quiet.

[@damarisscott7643]

Hi Jonathan, I was not able to join the Discord from the link provided. It says I do not have permisson to join.

[@SsaliJonathan]

Let me give you a new link

[@SsaliJonathan]

discord.com/invite/yqpwkwjRbx

[@TheHeroIsRisingUp]

is SQLModel a substitute for SQLAlchemy? any idea guys

[@SsaliJonathan]

Not really. It’s just a modification of, or think of it like a child of Sqlalchemy that’s built to have pydantic powers and can be used smoothly with modern python frameworks

[@TheHeroIsRisingUp]

@@SsaliJonathan Thank you bro! I am looking forward to this incredible tutorial.

[@andriykostenko3688]

Nice job !!!

[@SsaliJonathan]

Thank you! Cheers!

[@coff3andprograming]

I love FastAPI❤

[@SsaliJonathan]

Me too. It’s such a great framework

[@coff3andprograming]

I don't know if you have programmed with nestjs, but I feel that FastAPI is the lost brother of this framework since both offer fast, scalable APIs, they use data types, they can be structured almost the same way, they offer autocompletion in the editor, both have documentation in open api, etc.@@SsaliJonathan

[@macmillerlover]

hello jo, i wanted to make a request. could you please make a full course on testing with python? especially mocking

[@SsaliJonathan]

Got it. Will make one. Thanks for the suggestion

[@netkap9920]

awsome

[@derekstevens164]

My wife's son is gay

[@SsaliJonathan]

Does he use FastAPI?

[@derekstevens164]

@@SsaliJonathan no. Also, why do they not update SQLModel for the pacman library

[@SsaliJonathan]

@@derekstevens164 what is the pacman library?

[@derekstevens164]

@@SsaliJonathan I use arch linux

[@terryliu3635]

Great tutorial, thank you!!

[@SsaliJonathan]

I’m glad you liked it.