Explore the world of database management in Python with this PyCon US talk by Hannah Stepanek. Dive deep into SQLAlchemy and Alembic, learning about Object-Relational Mapping (ORM), database-agnostic query writing, and safe database schema modifications. Discover the benefits of connection pools, tackle challenges in large-scale operations, and understand the impact of lazy loading on performance. Gain insights into creating efficient database models, establishing connections, and implementing migrations. Learn to avoid common pitfalls and optimize your database interactions for production environments. By the end of this talk, you'll be equipped with the knowledge to simplify and streamline your database management processes, allowing you to focus more on feature development.
Let's Talk Databases in Python - SQLAlchemy and Alembic