Introducing Asynchronous SQLAlchemy

An overview of the asynchronous support introduced in SQLAlchemy 1.4

Sebastiaan Zeeff

ASYNC / Concurreny Databases Python 3 SQL Alchemy Tooling

See in schedule

With the increasing popularity of asynchronous frameworks, such as FastAPI, communicating asychronously with databases has become a hot topic in Python development. While there were already a lot of database drivers with asynchronous support available, support for asynchio in Object-Relation Mapping (ORM) frameworks was a lot rarer. That is, until the release of version 1.4 of SQLAlchemy back in March of 2021, which added support for Asynchronous I/O to one of the most popular ORM frameworks for Python.

In this talk, Sebastiaan Zeeff will give an overview of the newly added support for asyncio in SQLAlchemy. He will go over how easy it is to set up and use the new AsyncEngine, show you how to avoid getting bitten by some of the pitfalls, and explain how you can use the synchronous functions and methods of SQLAlchemy under asyncio.

While this talk is an introduction to SQLAlchemy's asyncio support, it is aimed at those who already have some experience with ORM and asyncio. Extensive knowledge of SQLAlchemy is not required, although having a bit of experience with the framework won't hurt.

Type: Talk (30 mins); Python level: Intermediate; Domain level: Intermediate


Sebastiaan Zeeff

Ordina

Sebastiaan is a Python enthusiast from Rijswijk in the Netherlands. He works as a Python software engineer for the Ordina Pythoneers, and he is active as a volunteer, open source contributor, and educator in the Python community. Sebastiaan is an owner of Python Discord, volunteer for EuroPython, and a Fellow the Python Software Foundation. One of the things is he loves most is teaching and helping others, especially when it comes to programming and Python.