February 26-28, 2025
Montreal, Canada
MySQL/PostgreSQL - A Guide to Using JSON_TABLE()
Do you store data in a MySQL or PostgreSQL database in JSON? One of the more amazing functions is JSON_TABLE(), which temporarily lets you transform that data from JSON into a relational table for processing with SQL (Aggragates, CTE, Windowing Functions, comparators). Great news, eh? Well, the bad news is that the documentation is not exactly helpful, and there are more than a few tricks to make life easier that you will see in this session.
Dave Stokes
Percona
Dave is a Technology Evangelist for Percona Corporation His background includes anti-submarine warfare, retail data collection, neural networks, device drivers, and too many databases. He lives in Texas with the mandated hound dog and pickup truck.
