Welcome to Percona Live Online 2021
Online Open Source Database Conference
Wednesday, May 12 • 14:30 - 15:00
JSON Additions in MariaDB - Featuring JSON_TABLE

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
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.

avatar for Vicențiu Ciorbaru

Vicențiu Ciorbaru

Team Lead, Senior Developer, MariaDB Foundation
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... Read More →

Wednesday May 12, 2021 14:30 - 15:00 EDT
Room #9