26 au 28 février, 2025
Montréal, 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.

Voir les 192 présentations

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.

Read More