Async SQLAlchemy - Async Database Engines, Sessions and FastAPI Dependencies

Description

▶ Django & HTMX FULL COURSE: https://www.udemy.com/course/django-htmx-hypermedia-web-apps/?couponCode=BUGBYTES-FEB 🙏 Join our channel to get access to perks: https://www.youtube.com/channel/UCTwxaBjziKfy6y_uWu30orA/join ☕️ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲: To support the channel and encourage new videos, please consider buying a coffee here: https://ko-fi.com/bugbytes In this video, we'll look at using asyncio with SQLAlchemy, and creating async engines, sessions and FastAPI dependencies which can be used in web APIs and applications. 📌 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀: 00:00 Intro 00:28 SQLAlchemy async - introduction 01:49 Why async? 03:36 Creating SQLAlchemy async engine 05:23 Async Sessions in SQLAlchemy 06:22 Async Session in FastAPI Dependency 09:06 Using async/await in FastAPI 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮: ▶ Udemy: https://www.udemy.com/user/bugbytes/ 📖 Blog: https://bugbytes.io/posts/ 👾 Github: https://github.com/bugbytes-io/ 📚 𝗙𝘂𝗿𝘁𝗵𝗲𝗿 𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗮𝗻𝗱 𝗶𝗻𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻: SQLAlchemy Async: https://docs.sqlalchemy.org/en/21/orm/extensions/asyncio.html aiosqlite: https://pypi.org/project/aiosqlite/ psycopg: https://www.psycopg.org/ #python #sqlalchemy #datascience