The magic of SQLAlchemy
summary
SQLAlchemy is presented as a two-layer toolkit: SQLAlchemy Core builds composable SQL via a Python expression AST, creates SQL strings plus parameter dicts, supports reflection of existing schemas and returns a result proxy with inserted rowcount and last-inserted PKs, while the ORM maps Python classes to tables and auto-generates init/metadata. Examples cite Reddit and Yelp using Core, version 1.0 arriving in 2015, current 1.2, and async DB APIs are not supported yet.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 1:23Common data structures
- 5:37Relational Database
- 6:43Sequel Alchemy
- 7:53Structure
- 12:38Examples
- 13:57Toy example
- 15:01Connection
- 16:43Metadata
- 18:48Reflect
- 19:43Sequel
- 20:33Insert
- 22:29Select
- 24:39ORM
- 27:32Question
related talks
01h 28mSQLAlchemy and You - Making SQL the Best Thing Since Sliced Bread
28mThe Ultimate Python Database Toolkit: SQLAlchemy
37mNo More Raw SQL with SQLAlchemy and ORMs
32mNo More Raw SQL: SQLAlchemy & ORMs
01h 58mNo More Raw SQL: SQLAlchemy, ORMs & asyncio
01h 44mTUTORIAL: SQLAlchemy 2.0
29mDatabase Sorcery 101 Ditch the Ancient SQL Scrolls for SQLModel
23mBuilding a multi-purpose platform for bulk data using sqlalchemy