Главная
Study mode:
on
1
Intro
2
What's an ORM?
3
Available Python ORMS
4
User Model
5
Common Base
6
Validation
7
Relationships
8
Unique Constraints
9
Multi Column Indexes
10
Partial Indexing
11
Functional/Expression Indexing
12
Connecting to the DB
13
Inserting Data
14
Using a Session Context Manager
15
Session Scoping
16
Establishing a DB Connection
17
Connection Pools
18
Creating the DB
19
Database Migrations
20
Database Migration Libraries
21
Configuration
22
Creating a Migration
23
Run the migration
24
Downgrade the migration
25
Modify an Existing Table
26
Modify Data
27
Problems in the Wild: Lazy Loading
28
Lazy Loading: What is it?
29
Lazy Loading: Why is it a problem?
30
Lazy Loading: Use Eager Load Instead!
31
Problems in the Wild: Unexpected Query Generation
32
Review
33
Questions
Description:
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

PyCon US
Add to list
0:00 / 0:00