Django with PostgreSQL superpowers
summary
Shows how to use psycopg3 with Django 4.1 and the django.contrib.postgres module to get real Postgres-only gains: random_uuid via pgcrypto for bulk UUID updates, JSONField and functional GIN search vectors with websearch syntax and faster queries, array and ranged fields, trigram similarity, and PostGIS for geodata. Demonstrates django_postgres_copy loading ~1 million rows in just over 3 seconds via temporary tables and compressed files, and ltree (L3) hierarchies with GIST indexes for fast tree queries.
AI-written summary · about
chapters (11)
- 0:00Introduction and setup
- 3:43Adding PostgreSQL to Django
- 5:15Django PostgreSQL module overview
- 7:01UUID generation with PostgreSQL
- 8:47Full-text search in Django
- 11:21PostgreSQL array fields
- 13:09Fast data import with Django PostgreSQL copy
- 15:56Tree structures with Django Ltree
- 17:50Geospatial features with PostGIS
- 19:18PostgreSQL tips for Django developers
- 20:46Resources and closing
related talks
23mDjango 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
26mPostgreSQL Generated Columns by Example
46mUse PostgreSQL to Step Up Your Game
31mSpace Django: Migrating and Redesigning a Database while Hunting for Satellites.