PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Andrew Dunstan
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Morisset 256
Start time 13:00
Duration 00:45
ID 715
Event type Lecture
Track 9.4 Features
Language used for presentation English

Json - what's new in 9.4, and what's left to do.

We'll cover the new Json generation functions, as well as jsonb, and when to use json, jsonb or hstore. We'll end by looking into the future to see what other json functionality might be coming, such as json mutation functions.

The talk will present a survey of the current and coming state of json features, as well as a speculative look at what which be in the future beyond 9.4

Overview: * the new json generation functions, such as jsonbuildobject and jsonbuildarray and how they can be used to build up arbitrarily complex and non-rectangular json. * json_typeof() * jsonb, and its relation to json and nested hstore. * how jsonb is different from json, (e.g. object field ordering, treatment of duplicate field names and whitespace) * performance differences between json and jsonb * what's missing from json/jsonb? What should we work on for 9.5? Mutation functions have been suggested, Are there others?