SQLAlchemy and You - Making SQL the Best Thing Since Sliced Bread
summary
Claims SQLAlchemy is the gold‑standard for Python SQL work and shows concrete, runnable examples: uses Core and ORM side‑by‑side, creates an engine + metadata + session, builds tables (Postgres and SQLite via Docker), loads a few thousand CSV rows, and computes an occupancy rate with CTEs that actually runs. Demonstrations show transactions, batched inserts, eager vs lazy relationship loading, hybrid properties, and the future=True migration to 2.0 that changes select/execute patterns.
AI-written summary · about
chapters (17)
- 0:00Start
- 6:30Sql Alchemy
- 10:09Adding a Where Clause
- 17:52Reflection
- 22:01Sql Statement
- 24:22Commit as You Go
- 37:17Refactor Your Sql
- 39:59Occupancy Rates
- 41:37Space Select Statements
- 53:19Error Messages
- 54:56Orms
- 1:02:38Relationships
- 1:13:03Scalars
- 1:13:59Shortcut Syntax
- 1:15:14Relationship Loading
- 1:20:23Hybrid Property
- 1:23:00Hybrid Methods
related talks
28mThe Ultimate Python Database Toolkit: SQLAlchemy
30mThe magic of SQLAlchemy
34mLet's talk Databases in Python: SQLAlchemy and Alembic
37mNo More Raw SQL with SQLAlchemy and ORMs
32mNo More Raw SQL: SQLAlchemy & ORMs
29mDatabase Sorcery 101 Ditch the Ancient SQL Scrolls for SQLModel
01h 44mTUTORIAL: SQLAlchemy 2.0
32mBecause SQL is everywhere but you don't want to use it