XML, HSTORE, JSON, JSONB—OH MY!

XML, HSTORE, JSON, JSONB—OH MY!

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.

397f829eea921e02e35c37c22f9e6d3b?s=128

David E. Wheeler

May 23, 2014
Tweet