PostgreSQL and MySQL can do JSON too

Drupal Mountain Camp, Davos, Switzerland - 12. March 2025

© David Buchmann

David Buchmann - david@liip.ch

PHP Engineer, Liip AG, Switzerland

Why store JSON in a relational database?

• Store unstructured or semi-structured data
• Do not bother to denormalize everything when not necessary
• Your NoSQL database at home?

Repository

Repository at github.com/dbu/postgres-json
and github.com/dbu/postgres-json/pull/2 for MySQL