Simon Charette

3 videos · 3 events · 2022–2025 · 2h 8m of video

Talks

0:43:46

Django, what the JOIN?

Djangonaut Space 2025 · October 23, 2025

A SQL join combines rows across related tables: inner joins keep matching rows, while outer joins also preserve unmatched rows with NULLs. Django chooses between them based on whether a relationship can be missing, whether a filter rules out missing values, whether an expression such…

0:44:26

Demystifying the Django ORM

Djangonaut Space 2024 · November 18, 2024

Simon Charette explains Django’s ORM as a mapping between Python model objects and relational database tables, then breaks query processing into four phases: resolving, compilation, execution, and construction. Resolving builds and validates a lazy, database-agnostic expression tree; compilation turns it into backend-specific SQL and parameters;…

0:40:08

State of the Object-Relational Mapping (ORM)

DjangoCon US 2022 · November 24, 2022

Simon Charette reviews the Django ORM features that most changed how developers work, including `prefetch_related`, transaction management, custom lookups and expressions, subqueries, and constraints. He then examines persistent problems: duplicate rows and incorrect aggregates across multi-valued relationships, implicit versus deferred field loading and N+1 queries,…

Spoken at