Christophe Pettus

2 videos · 2 events · 2015–2016 · 1h 4m of video

Talks

0:20:44

Django and PostgreSQL: An Even-Closer Union

DjangoCon US 2016 · August 10, 2016

Christophe Pettus explains how Django’s PostgreSQL-specific features expose native database types, including arrays, ranges, JSONB, and full-text search. He shows the query operations these fields support, emphasizes choosing the appropriate PostgreSQL indexes—GIN, GiST, or expression indexes—and warns that Django’s generic B-tree index is often unsuitable.…

0:43:31

PostgreSQL in Django 1.8

DjangoCon US 2015 · September 18, 2015

Django 1.8’s PostgreSQL support adds first-class array, range, and hstore fields, while Django migrations provide the operations needed to install extensions and create PostgreSQL-specific indexes and constraints. Array fields are useful for genuinely list-shaped data or carefully chosen denormalisations; GIN indexes speed up containment and…

Spoken at