PostgreSQL in Django 1.8
summary
Django 1.8 delivers concrete PostgreSQL features: use create_extension migration to install hstore or btree_gist, store lists with array fields and query with contains/contained_by/overlaps, accelerate those with a GIN index or build expression indexes (array_length, slices), and model ranges with range fields plus gist-backed indexes. The demo shows an exclusion constraint combining room + daterange (via btree_gist) that prevents double bookings at the database level. Watch if needing these exact tools and constraints; skip if the talk stays at theory.
AI-written summary · about
chapters (14)
- 0:00Introduction to migrations
- 1:16Database operations
- 3:23Array fields
- 5:21Querying array fields
- 8:24Indexing array fields
- 11:27Advanced indexing techniques
- 13:41Array field use cases
- 16:03HStore fields
- 19:23Indexing and using HStore
- 21:44Range fields
- 24:48Indexing range fields
- 27:23Exclusion constraints
- 30:26JSON support
- 33:40Q&A and conclusion
related talks
21mDjango and PostgreSQL: An Even-Closer Union
22mDjango with PostgreSQL superpowers
23mDjango with PostgreSQL superpowers
46mUse PostgreSQL to Step Up Your Game
46mPostgreSQL Beyond Django: Strategies to Get Max Performance with Álvaro Justen
43mOptimize Python & Django apps with Postgres superpowers
29mPostgres Demystified
33mPostgres, the Best Tool You're Already Using