Presented by:

Stoker

Dave Stokes

Percona

Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide and a Technology Evangelist for Percona.

No video of the event yet, sorry!

JSON has become the data interchange format for most developers. Storing JSON data in a JSON data type is old news in the PostgreSQL world. But JSON_TABLE() is new in version 17. It lets you temporarily convert from JSON into a relational table for processing with SQL commands, such as CTEs, Window Functions, Aggregate Functions, and the like. This is an introductory-level presentation to introduce you to JSON_TABLE() and discuss some of the finer points of its use.

Date:
2024 November 6 10:40 PST
Duration:
20 min
Room:
Essentials: 420
Conference:
Seattle 2024
Language:
Track:
Essentials
Difficulty:
Medium