TS4: NoSQL on ACID - Using Postgres for Unstructured Workloads

PostgreSQL features a powerful storage format for unstructured document data that combines the flexibility of schema-less design with the ACID properties of relational. Introduced in PostgreSQL 9.4, JSONB, a higher-performance than the original JSON type, comes with indexing, functions and operators for manipulating and integrating JSON data easily with record-oriented data in Postgres.

This workshop will include instruction for several scenarios for working with JSON in PostgreSQL and demonstrate performance metrics. It will also provide instruction on how to use different operations.

The workshop 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

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996 as a committer and community leader. Bruce is employed by EnterpriseDB as a Senior Database Architect. Previously, he was employed by SRA Japan and other PostgreSQL support companies. . Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world's largest law firms. As an academic, Bruce holds a Masters in Education, was a high school computer science teacher, and is currently an adjunct professor at Drexel University.

Vibhor Kumar is a principal system architect at EnterpriseDB who specializes in assisting Fortune 100 companies to deploy, manage, and optimize Postgres databases. He joined EnterpriseDB in 2008 to work with Postgres after several years of working with Oracle systems. He has worked in team leadership roles at IBM Global Services and BMC Software as well as an Oracle database administrator at CMC Ltd. for several years. He has developed expertise in Oracle, DB2, and MongoDB and holds certifications in them. He has experience working with MS SQL Server, MySQL, and data warehousing. He holds a bachelor's degree in computer science from the University of Lucknow and a master's degree in computer science from the Army Institute of Management, Kolkata. He is a certified PostgreSQL trainer and holds a professional certification in Postgres Plus Advanced Server from EnterpriseDB.