About the show Sponsored by us! Support our work through: Connect with the hosts Join us on YouTube at pythonbytes.fm/live to be part of the audience. Usually Monday at 11am PT. Older video versions available there too. Finally, if you want an artisanal, hand-crafted digest of every week of the show notes in email form? Add your name and email to our friends of the show list, we'll never share it.
Asyncpg is the connector for PostgreSQL and asyncio-flavored Python. Here's how to use it without other libraries on FastAPI and Air projects. Recently I've been on a few projects using PostgreSQL where SQLAlchemy and SQLModel felt like overkill. Instead of using those libraries I leaned on writing SQL queries and running those directly in [asyncpg](https://pypi.org/project/asyncpg/) instead of using an ORM powered by asyncpg. Here's how I got it to work
The Python standard library provides the asyncio module to facilitate writing high-performance concurrent code. By leveraging async/await syntax, it provides a high level API for creating and managing event loops, coroutines, tasks, and performing asynchronous I/O operations. It is used as a foundation for Python asynchronous frameworks that provide high-performance network and web-servers, database connection libraries, distributed task queues, etc. Multiple libraries and frameworks, such as FastAPI and aiohttp, are built on top of asyncio.
Christopher covers a recent Real Python tutorial about developing mixin classes to reuse code across multiple Python classes. He describes how mixins rely on multiple inheritance to combine features from different classes, enhancing flexibility and code reuse.
