PgConf.Russia 2017 talks

Complex structures without ORM

Philip Delgyado
ITIS Ltd, Head of Development Department

Philip has been engaged in a wide range of IT-activities, from two-links on Visual Basic to the core SQL development. Last years he has been working mainly with high-load projects on Java. At different times he has developed the biggest in Russia bookmaking engine and the Yandex.Money service, now he is developing a specialized payment system. Philip makes talks at different conferences regularly.

I love complex knowledge domains, strong typing in applications, and 3NF, but I hate ORM. That is why I’ve been actively storing serialized structures in JSON fields (even before the JSON type was introduced). In this talk, I will tell you about some specifics of storing complex structures within DBMS fields, what problems can arise, and how to cushion the blow.