Let's Talk Databases in Python - SQLAlchemy and Alembic

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.

Intro
What's an ORM?
Available Python ORMS
User Model
Common Base
Validation
Relationships
Unique Constraints
Multi Column Indexes
Partial Indexing
Functional/Expression Indexing
Connecting to the DB
Inserting Data
Using a Session Context Manager
Session Scoping
Establishing a DB Connection
Connection Pools
Creating the DB
Database Migrations
Database Migration Libraries
Configuration
Creating a Migration
Run the migration
Downgrade the migration
Modify an Existing Table
Modify Data
Problems in the Wild: Lazy Loading
Lazy Loading: What is it?
Lazy Loading: Why is it a problem?
Lazy Loading: Use Eager Load Instead!
Problems in the Wild: Unexpected Query Generation
Review
Questions