Let's Talk Databases in Python - SQLAlchemy and Alembic

This talk explains how to manage production databases with SQLAlchemy and Alembic, from modeling data and managing connections to applying schema changes safely. It also examines performance issues such as lazy loading and unexpected query generation.

Syllabus

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