ORM: The Sequel
summary
A running demo of the UnicodeX app shows how to inspect schema and rows from the manage.py shell, enumerate models via Model._meta.get_fields, and run queries with .objects.all(), .filter(), .get() and Q objects for AND/OR/NOT logic. The talk shows counting results (44 matches), a mistaken chain of filters producing 712 rows from duplicated joins, and debugging a broken Twitter image entry. It prints generated SQL via connection.queries and advises raw SQL only when necessary and to use IPython for convenience.
AI-written summary · about
chapters (5)
- 0:00Introduction
- 5:50Debugging with Django shell
- 14:04Querying and joins in ORM
- 26:52ORM in practice debugging
- 30:24ORM tips and conclusion
related talks
27mORM: The Sequel
39mLet's Build an ORM
21mCustom Model Managers and QuerySets: Graduating from Django Beginner to ORM Master
30mLeave Your Inhibitions at the Database Connection
29mDatabase Sorcery 101 Ditch the Ancient SQL Scrolls for SQLModel
01h 04mInside the ORM
32mNo More Raw SQL: SQLAlchemy & ORMs
25mFrom Legacy to Admin