The Ultimate Python Database Toolkit: SQLAlchemy
summary
Claims SQLAlchemy is a high‑performing, modular, non‑opinionated Python database toolkit and demonstrates that by walking through core and ORM parts, showing actual code: create_engine, engine.connect(), Table/Column metadata, and session usage. It targets Postgres MySQL MSSQL SQLite Oracle and more, builds SQL via the expression language (select, func, case, joins), supports master/slave sessions and relationship loading strategies, and shows inserts/updates/deletes generated and executed against a live connection.
AI-written summary · about
chapters (9)
- 0:00Introduction to SQLAlchemy
- 1:40Understanding SQLAlchemy Core
- 3:51Defining Tables and Columns
- 7:01Querying with SQL Expression
- 10:53Advanced Query Operations
- 13:50Using SQL Functions
- 16:54ORM and Session Management
- 20:05ORM Queries and Updates
- 22:23Relationships and Loading
related talks
01h 28mSQLAlchemy and You - Making SQL the Best Thing Since Sliced Bread
30mThe magic of SQLAlchemy
34mLet's talk Databases in Python: SQLAlchemy and Alembic
01h 44mTUTORIAL: SQLAlchemy 2.0
01h 58mNo More Raw SQL: SQLAlchemy, ORMs & asyncio
53mSqlkit: empowering database access
37mNo More Raw SQL with SQLAlchemy and ORMs
32mNo More Raw SQL: SQLAlchemy & ORMs