JSON in Postgres The Present and Future

Jsonb in Postgres is one of the attractive feature for modern application developers, which allows efficient work with json documents without sacrificing strong consistency and ability to use all the power of proven relational technology. The rich Jsonb infrastructure in Postgres, which includes a lot of functions, operator, indexes and other details, might be difficult to users, that is why we will provide a guidance of how to use jsonb: how to generate or convert data into jsonb, how to manipulate your jsonb data, how to avoid common mistakes and performance problems. We will also present results of universally recognized YCSB benchmarks for PostgreSQL, MongoDB and MySQL. Also, we will discuss some new jsonb functionality expected in future releases, including support of SQL-2016 standard , jsonb compression, better support for long jsonb documents and others.