Cleaner Code, Better Queries: SQLAlchemy, ORMs and asyncio

Managing a database and synchronizing service data representation with the database can be tricky. In this workshop, you’ll learn how to use SQLAlchemy, a powerful SQL toolkit, to simplify this task. We’ll cover how to leverage SQLAlchemy’s Object Relational Mapper (ORM) system, and how to use ORM’s asyncio extension in your async services. Participants will walk out of this tutorial having learned how to:

• Use SQLAlchemy for database operations in Python, enhancing the readability and maintainability of the code
• Build Python classes (ORMs) that represent the database tables
• Experiment with different relationship-loading techniques to improve querying performance
• Utilize SQLAlchemy’s asyncio extension to interact with databases asynchronously