Boriss Mejias. JSON in PostgreSQL - Learning with a case study // скачать в хорошем качестве

Boriss Mejias. JSON in PostgreSQL - Learning with a case study //

PostgreSQL provides great support for JSON objects and every developer working with this data type should learn how to take advantage of it. Instead of going through the documentation on how to use JSON in PostgreSQL, in this talk we will use a case study to learn by example. We will also complement the usage of JSON by introducing other data types such as ARRAY. We will also review some design decisions to turn JSON objects into columns and vice versa when it's convenient. This talk will help you to axe the archaic Entity-Attribute-Value (EAV) pattern from your database. ~~~ About Boriss Mejias: "I'm a holistic system software engineer (aka Solution Architect), PostgreSQL consultant and trainer, free software user, and headbanger. I have been working with PostgreSQL since version 9.1. First, as part of my job related to other projects, and with full dedication since 2017. I have a background as teaching-assistant and researcher on self-managing distributed systems. In 2018 I have started the PostgreSQL User Group in Belgium."