PyCon 2016 in Portland, Or
hills next to breadcrumb illustration

Monday 3:15 p.m.–4 p.m.

Django 1.8/1.9 and PostgreSQL: An Ever-Closer Union

Christophe Pettus

Audience level:
Web Frameworks


Django 1.8/1.9 adds a whole bunch of cool new features that are specifically designed for PostgreSQL. We'll take a quick tour through them, and show when and how you can use them in real-world applications. We'll also talk about how to get the best performance out of PostgreSQL when using the Django ORM.


Django 1.8 introduced a large number of advanced PostgreSQL-specific features, and Django 1.9 extends them. We'll dive into them in detail, and explain why a developer might use them, and the advantages and disadvantages of each. Among the features that we'll discuss are: * Range fields and indexing * UUIDs * JSON fields * Array fields * HStore fields ... along with their supporting infrastructure.