Django with PostgreSQL superpowers
summary
Shows how to wire PostgreSQL into Django using psycopg3, Django’s contrib.postgres and a few third‑party packages, demonstrates updating nearly one million UUIDs with the randomUUID function instead of Python loops, and imports almost one million CSV rows in about three seconds using Django Postgres Copy’s temp-table/COPY pipeline. Covers JSONField, ArrayField, GIN index backed full‑text search, ltree hierarchical queries and PostGIS usage, with concrete migration and index choices and SQL patterns that actually speed queries.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:52Django no code
- 2:39Psycopg
- 4:41Test queries
- 5:55PostgreSQL contrib
- 7:26Random UUID
- 9:47Full Text Search
- 11:52Array field
- 13:49Django Postgres copy
- 16:53Django ltree
- 18:51PostGIS
- 19:42What’s next
related talks
22mDjango with PostgreSQL superpowers
21mDjango and PostgreSQL: An Even-Closer Union
46mPostgreSQL Beyond Django: Strategies to Get Max Performance with Álvaro Justen
44mPostgreSQL in Django 1.8
43mOptimize Python & Django apps with Postgres superpowers
31mSpace Django: Migrating and Redesigning a Database while Hunting for Satellites.
26mPostgreSQL Generated Columns by Example
46mUse PostgreSQL to Step Up Your Game