Dave Stokes
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.
Sessions Montréal 2025
MySQL/PostgreSQL - A Guide to Using JSON_TABLE()
Session en anglais - Avancé
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.
Valkey - The Basics
Session en anglais - Débutant
Valkey is less than a year old but has come as a strong replacement for Redis (they changed to a non-open source license). Valkey is an open-source in-memory storage, used as a distributed, in-memory key–value database, cache and message broker, with optional durability. Valkey is memory-based, and because of its design, Valkey offers low-latency reads and writes, making it particularly suitable for use cases that require a cache.
