Presented by:

40170d6706798e0a5a2e82d3c917224c

Ivan Panchenko

from Postgres Professional

Ivan is a well known member of Russian PostgreSQL community, the organizer of PgConf.Russia events. He is a PostgreSQL enthusiast, as well as a professional astrophysicist and software developer. Since starting developing PostgreSQL-based applications in 1998 Ivan got a significant experience in both PostgreSQL and enterprise requirements for databases. As a co-founder and Deputy CEO of Postgres Professional, Ivan is responsible for working with enterprise customers and defining the product strategy.

No video of the event yet, sorry!

This talk describes some practical cases of JSON usage with the compendium of corresponding PostgreSQL JSON tools: SQL functions and operators, including the new ones introduced in PostgreSQL 12 according to SQL:2016 standard, JSQuery extension, aggregates, recursive CTE, special indexes for JSON search, JSON support in server-side procedural languages. The talk is illustrated by numerous examples.

Date:
Duration:
40 min
Room:
Conference:
PGConf India, 2020
Language:
Track:
Application Developer
Difficulty:
Medium