SQLAlchemy and data access in Python

Episode #5, published Tue, Apr 28, 2015, recorded Thu, Apr 9, 2015

In this episode we speak with Mike Bayer. Mike created SQLAlchemy in 2005 and over the past 10 years has been building and refining this amazing RDBMS ORM and data access layer.

You'll learn a lot about the history of the project and how it has evolved over time. You'll also here where Mike got some of his inspiration for the design patterns used in the library.

So what are you waiting for? Maybe it's time to

pip install sqlalchemy

Links from the show:

SQLAlchemy Site:
http://www.sqlalchemy.org/

Asynchronous Python and Databases:
http://techspot.zzzeek.org/2015/02/15/asynchronous-python-and-databases/

Hybrids and Value Agnostic Types:
http://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/

Book: Essential SQLAlchemy:
amzn.to/1Dw3YHY

Book: SQLAlchemy: Database Access Using Python:
amzn.to/1Dw4m9a

Want to go deeper? Check out our courses

Course: Python for the Absolute Beginner course

Course: HTMX + Flask: Modern Python Web Apps, Hold the JavaScript

Course: Modern APIs with FastAPI and Python

Mike Bayer

Michael Bayer is the creator of several prominent Python libraries including SQLAlchemy, Mako Templates for Python, Alembic Migrations, and Dogpile caching. He has been working with open source software and databases since the mid-1990s. Today he's active in the Python community, working to spread good software practices to an ever wider audience. Mike is a semi-regular presenter at Pycon US and has also spoken at many smaller events and conferences in the US and Europe. Follow Mike on Twitter at @zzzeek.

Episode sponsored by

Ads served ethically