PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

David E. Wheeler
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Morisset 256
Start time 15:15
Duration 00:45
ID 684
Event type Lecture
Track 9.4 Features
Language used for presentation English


Use the unstructured data type that's right for you.

PostgreSQL 9.4 adds a new unstructured data type, JSONB, a variant of JSON optimized for storing objects. JSONB complements the existing XML and JSON document objects, as well as HSTORE. Which one is right for you? We'll take a tour of the features of each, and their advantages and disadvantages for various use cases, all illustrated with real-world examples.

There has been a lot of work on the representation of unstructured data in PostgreSQL, culminating in the addition of the JSONB type in the forthcoming 9.4 release. JSONB complements the existing HSTORE, XML, and JSON types, not to mention arrays. With so many options, which do you use? As usual it depends on your use case.

In this presentation, we'll review the unstructured data types in PostgreSQL, and look at their advantages and disadvantages for:

  • Document storage
  • Configuration management
  • A “schemaless database”
  • Object serialization
  • Entity/Attribute/Value models
  • Path queries