Practical JSON
Presented by:
Ivan Panchenko
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.
Download slides
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:
- 2020 February 28 - 12:30
- Duration:
- 40 min
- Room:
- Grand Victoria 2
- Conference:
- PGConf India, 2020
- Language:
- Track:
- Application Developer
- Difficulty:
- Medium
- Contributing to PostgreSQL Open Source Community: Viewing PostgreSQL from different angles.
- Start Time:
- 2020 February 28 12:30
- Room:
- Grand Victoria 1