JSON Additions in MariaDB - Featuring JSON_TABLE

Speakers:  Vicențiu Ciorbaru

Vicențiu Ciorbaru - MariaDB Foundation - Percona Live 2021 - MariaDB Track Room

MariaDB has had JSON support for a while now. Released initially in 10.2, MariaDB tries to follow the SQL standard as close as possible. One of the new additions coming to MariaDB 10.6 is support for JSON_TABLE. In this talk we will go through the details of this new feature, as well use cases and interactions with JSON path. We will also compare MariaDB’s implementation to other databases, so that you are aware of pitfalls if a migration is due. On the topic of migration, MariaDB has also introduced a data type plugin that understands MySQL’s binary JSON format and coverts it to MariaDB’s text based representation, without needing to do a full dump and restore. ∎

Video

Link: https://youtu.be/5qgOtqc1y4Y

Speakers

Vicențiu Ciorbaru

MariaDB Foundation, Team Lead, Senior Developer

Vicentiu works at the MariaDB Foundation as a Software Engineer and Team Lead. He focuses on optimizer development, but has also worked on other parts of the MariaDB Server. Vicențiu has been part of the MariaDB ecosystem since 2013, where he first contributed Roles to MariaDB. Over the years, Vicențiu has coded numerous features and helped with the packaging of MariaDB for various distributions. Recently, Vicențiu has also been involved in the QA process of MariaDB, by contributing to https://buildbot.mariadb.org as well as mariadb.org/download infrastructure

See all talks by Vicențiu Ciorbaru »

Did you like this post? Why not read more?

Percona Community Live June 21 - Day 1

Percona Community Live June 21 - Day 1

You are invited to participate in the first day of the Percona Community Live stream! Learn about VictoriaMetrics, flexible Indexing with Postgres, PostgreSQL backups, database resiliency, and many other things on June 21st. Join us on June 22nd and June 23d for more amazing content!

Read more »

Data Gravity Episode 3 - benny Vasquez - AlmaLinux Project and the Future of Databases

Data Gravity Episode 3 - benny Vasquez - AlmaLinux Project and the Future of Databases

In this episode, Joe Brockmeier interviews benny Vasquez of the AlmaLinux Project to discuss open source data, the future of databases, and how databases and Linux distros go together.

Read more »

Data Gravity Episode 2 - Sonia Valeja and David Gonzalez - PostgreSQL for Jobseekers Book

Data Gravity Episode 2 - Sonia Valeja and David Gonzalez - PostgreSQL for Jobseekers Book

In this episode, Joe Brockmeier talks to Percona’s Sonia Valeja and David Gonzalez, about their recent book PostgreSQL for Jobseekers. They talk about the inspiration for the book, why they focus on jobseekers, and what’s covered in the title.

Read more »

✎ Edit this page on GitHub