Using Storm to work with SQL databases
summary
Practical intro to the Storm ORM: origins (started using 2006, open‑sourced 2007) and engineering choices — test‑first development with near‑100% test emphasis and two‑review changes, focused support for SQLite/Postgres/MySQL, and deliberate avoidance of complex table inheritance. Shows the actual API: Database/Store, serializable transactions by default, store.execute behavior and flush cases, caching of live objects, and common pitfalls (N+1 loads, heavy object caching). Demonstrates fixes: use of values() for column lists, subselect expressions, tracers for SQL, Twisted/Django/Zope integration, and a Collections pattern for query composition.
AI-written summary · about
chapters (12)
- 0:00Introduction to Storm
- 3:36Design goals and principles
- 7:42Storm features and development
- 10:41Using stores and transactions
- 16:35Concurrency and threading
- 19:33Defining models and queries
- 24:27References and relationships
- 30:40Advanced querying techniques
- 36:42Performance and data fetching
- 43:42Advanced database features
- 51:55Traces, hooks, and integration
- 58:00Design patterns and Q&A
related talks
30mBuilding an ORM with AReL: Walking up the (AS)Tree.
01h 01mStream Data Processing for Fun and Profit
02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB Effectively
41mAn Object Oriented Approach to Data Driven Software Development
01h 29mWorking with Databases and Groovy
52mData storage for modern applications - Mike Lehan
01h 27mAdvanced GORM: Beyond Relational
48mThe DB tamer