Using JSONB


Nikolay Ryzhikov

Health Samurai

CTO

Марат Сурмашев

Health Samurai

Программист

JSONB in PostgreSQL has interesting properties for design and development of business systems with heavy domain, helping to fight against complexity and variability. We will discuss the trade-offs of the JSONB approach. Using an open source project for Health IT - fhirbase we will:

  • load synthetic medical data into PostgreSQL
  • learn how to search and index this data (gin, jsquery, json-knife)
  • use JSON aggregation to build complex queries (GraphQL)
  • see how this data can be modified and validated
  • discuss architecture consequences of JSONB usage

Technical requirements:

  • docker
  • docker-compose

Detailed prerequisites

Slides: https://gist.github.com/niquola/bcc90d57425b2a6c3324ea38ad6bc5b0

Video available to conference participants only. Account