NoSQL on ACID

Maximizing Results with JSONB and PostgreSQL

PostgreSQL has kept up the momentum around JSON with version 9.4 featuring JSONB as demand for working with unstructured data continues to grow. PostgreSQL 9.4 introduces the new JSONB "binary JSON" type. This new storage format for unstructured document data is higher-performance than the original JSON type, and comes with indexing, functions and operators for manipulating and integrating JSON data easily with record oriented data in Postgres. This class will include instruction for several scenarios for working with JSON in PostgreSQL and demonstrate performance metrics. This class will also provide instruction on how to use different operations.

The course will cover the following topics:

Overview of JSON - history, data types and operators
Why not HSTORE?
Intro to node.js with examples
Working with JSON - examples of SELECT, UPDATE, etc.
Integrating in applications
Performance benchmark