Nikolay Ryzhikov

Health Samurai


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

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


Video available to conference participants only. Account