FastAPI Essentials - CRUD API with a Database and SQLModel

In this video, we'll look at integrating FastAPI with a relational database, and will use the SQLModel library to interact with the database to query records as well as insert, update and delete data.

▶️ Full Playlist:

📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 Intro
01:31 Modelling data with Pydantic
03:38 Creating FastAPI application
06:20 Endpoint: GET ALL tracks
07:37 Endpoint: GET track by ID
10:59 Endpoint: POST new track
15:09 Endpoint: PUT track update
18:48 Endpoint: DELETE track

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

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

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

#fastapi #python #pydantic

[cutlervufamily]

Thanks for this series of videos. Really appreciate the clear explanations and references back to the documentation.

[Herdogan]

Another perfect video. Thanks a lot for providing them, really appreciated. Looking forward to see more content with the time.

[seydinaoumarsamabaly]

I started fastapi and stopped months ago. Now it's time to start over because it's explained by one of the best masters on the net. Thank you for all mate 🙌. Always a pleasure to wacth your videos.

[UsedYourName]

ur very precise in ur explanations lol I really hope u get the recognition u deserve because the quality of the videos is mad fire dawg

[GavinElie]

Your videos are clear and to the point.👍Keep up the good work!! Does SQLModel simplify database integration as opposed to using SQLAlchemy directly?? In other words, does it produce cleaner code?

[CarstenAevermann]

In the current video about alpinejs you convert data from SQL to json for frontend filtering. Could you explain what's the best approach when such lists are huge? Is it still appropriate to filter in frontend or is there a better way? How to decide where the sort/filtering happens (frontend/alpinejs vs backend/fastAPI/sql ) thx and your explanations are a great help and didactically the best.

[koshkinndom]

i just leave a comment here to help the channel with the promotion =)

[fidelischukwunyere]

Great video... Is there any difference when using async functions?

[IPADrinker]

@BugBytes can we see an example of GET route returning results from two joined tables?

[kerwbstomp]

Would HTMX be something that would be easy to implement as a front end with FastAPI?

[OSCARCORTEZVILLCA]

I can not find the github repo. Could you share the link please?