Speaker Deck

XML, HSTORE, JSON, JSONB—OH MY!

by David E. Wheeler

Published May 23, 2014 in Programming

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.