JSON in PostgreSQL - Learning with a case study

" summary

Shows how to use PostgreSQL JSON support (plus ARRAY and other types) through a concrete case study: practical examples for storing, querying and transforming JSON objects into regular columns and back. Covers design decisions and techniques to replace Entity‑Attribute‑Value (EAV) patterns with native JSON/array-based schemas and operations.

AI-written summary · about

" related talks

• 25mJSON in PostgreSQL - evil data type or just needs to be tamed?Boriss Mejias · POSETTE: An Event for Postgres 2026
• 49mShould I use JSON in PostgreSQL?Boriss Mejias · PostgreSQL Conference Europe 2023
• 14mJSON data structure – the hidden gem inside your database engineMizanur Rahman · PHPConf.Asia 2018
• 50mUsing JSON with Postgres 9 3Andrew Dunstan · PostgresOpen 2013
• 05mPostgreSQL JSON JSONB Making the Right Choice for Your ApplicationTummala Aswini Kumar · PGConf India 2025
• 42mHow to Store JSON in a Database Without Attracting the DBA's AttentionIlya Sazonov, Fedor Sazonov · Joker 2022
• 22mJSON in the Database, Let’s Play with That a BitJonathan VAN BELLE · Forum PHP 2020
• 51mDealing with JSON in the relational worldAndres Almiray · Devoxx Belgium 2024