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.
- 40 min
- PGConf India, 2020
- Application Developer