PgConf.Russia 2017 talks

PostgreSQL JSON Roadmap

Oleg Bartunov
Postgres Pro, CEO

Oleg Bartunov is the most famous Russian PostgreSQL developer, working on it more than 20 years.

The new ISO/IEC 9075-2:2016 standard specifies JSON data and operations syntax and semantics specifics for SQL. This talk overviews the requirements of this standard, and focuses on the differences between them and the actual implementation of JSON/JSONB in PostgreSQL. Special attention will be paid to JSON Path (XPath analogue), SQL/JSON functions and our plans to make Postgres compliant with this standard.