The Entity-Attribute-Value (EAV) data model is a design pattern to overcome the limitations of traditional relational databases. Its goal is to encode entities with a variable and a disparate number of attributes. It is efficient in terms of storage and it respects the rules of normalization. However, it doesn’t scale well, it degrades performance in the mid-term, and it complicates your software design, from the backend to frontend. It has been used for many years because there wasn’t anything better.
With PostgreSQL support for JSON and ARRAY, it is not only possible to stop using this deprecated pattern entirely, but it also feels natural to design entities with different attributes.
In our previous webinar "Fantastic Data Types and Where to Use them", we gave a short hint on how to do this.
Because of the interest and positive reactions, we decided to explore this topic in detail and arranged a live webinar, “JSON & ARRAY – Contemporary PostgreSQL Data Types”, entirely dedicated to JSON/JSONB/ARRAY, and how to axe the archaic EAV pattern from your database.
The session was hosted by Boriss Mejías PostgreSQL Consultant and Trainer at 2ndQuadrant.
Below is a preview of the webinar. Those who weren’t able to attend the live webinar can now view the recording here.
To be the first to know about upcoming PostgreSQL webinars by 2ndQuadrant, visit our Webinars page.
For any questions, comments, or feedback, please visit our website or send an email to [email protected].