Change the future

Sunday 1:50 p.m.–2:20 p.m.

Going beyond the Django ORM limitations with Postgres

Craig Kerstiens

Audience level:
Intermediate
Category:
Databases/NoSQL

Description

With most frameworks the ORM attempts to treat all databases equally, this results in developers being limited in how many advantages they can take of their database. In particular Postgres has many features which developers would love to take advantage of but are not easily accessible via the Django ORM.

Abstract

With most frameworks the ORM attempts to treat all databases equally, this results in developers being limited in how many advantages they can take of their database. In particular Postgres has many features which developers would love to take advantage of but are not easily accessible via the Django ORM. This talk will cover:

  • Tour of the cool features in Postgres (5 minutes)
  • Highlight limitations within ORM (5 minutes)
  • Using hStore within Django (a key/value datatype as a column, or known as NoSQL in your SQL DB) (7/8 minutes)
  • Taking advantage of Full Text Search (3/4 minutes)
  • Array Datatypes as a field and within your DB (3/4 minutes)
  • Using SQL functions with the ORM (5 minutes)
  • Wrap up