title

text

Nikolay Ryzhikov
Nikolay Ryzhikov Health Samurai
М
Марат Сурмашев Health Samurai
16:30 04 February
90 мин

Using JSONB

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

Материалы к докладу

слайды

Видео

Другие доклады

  • Miroslav Šedivý
    Miroslav Šedivý solute GmbH
    90 мин

    Python and PostgreSQL Using psycopg2

    Python may not be the fastest programming language on the CPU, but its fast and easy development saves a lot of costs between the keyboard and the chair. In this workshop we'll explore the most popular library for the access to the PostgreSQL server named "psycopg2" and write a short application using some of its useful features.

  • Teodor Sigaev
    Teodor Sigaev Postgres Professional
    22 мин

    Less known but worthwile PostgreSQL extensions

    Postgres is known for it extensibility, which made it the universal database, that means it can meet the requirements of practically any project. Many extensions are well-known and widely used, for example, PostGIS extension - de-facto standard of open source GIS, hstore - an extension for storing and manipulation of arbitrary key/value pairs. I will talk about less known but useful PostgreSQL extensions, which provides a new functionaliy and/or improve the performance of PostgreSQL.

    PostgreSQL was designed to be extensible, it provides an API to application developers to extend PostgreSQL functionality and/or improve the performance for specific data and workloads. It is important that there is no need of having expertise of core developers, and these new functionality could be added online without restarting of database server. Application developer can create various database objects, such as functions, data types, operators, indexes, and even new access methods.

    I will present my choice of two extensions out of hundreds:

    vops - greatly improves the performance of Postgres for OLAP queries using vector operations, pg_variables - provides session variables for storing scalars and relations, useful for generating reports on read-only replicas.

  • Alexey Ignatov
    Alexey Ignatov Postgres Professional
    Artem Ivanov
    Artem Ivanov Atos IT S&S
    22 мин

    Migration to PostgreSQL/Postgres Pro on multi-core Bull servers. With your own hands-on experience.

    To migrate to a PostgreSQL/Postgres Pro we need multi-core servers to be carefully tuned for correct parallelism. What settings make multi-terabyte installations work fast and correctly?

    We will share our PostgreSQL/Postgres Pro on BullSequana S and Bullion S servers testing experience.

      The features of this hardware platform which are crucial for high-loaded configurations
    • Multi-core Scale-up servers and PostgreSQL/Postgres Pro
    • Results of stress testing of PostgreSQL/Postgres Pro running on the equipment.
  • Darafei Praliaskouski
    Darafei Praliaskouski Juno
    45 мин

    PostGIS for Disaster Management

    PostGIS is spatial extension for PostgreSQL.

    This talk will go in depth on using PostGIS for disaster management: which functions can be used and for what.