MariaDB Community Server 10.6 extends JSON and Oracle compatibility

MariaDB announced the general availability of MariaDB Community Server 10.6, a major new release that brings significant advancements to the open source MariaDB community.

MariaDB Community Server 10.6 adds important features for developers with JSON table functionality, frees users from expensive proprietary ties with expanded PL/SQL compatibility and adds powerful insurance for bad database days with atomic DDL that supports MariaDB’s multiple storage engine architecture.

Finally, MariaDB’s columnar engine for powerful analytics received major upgrades for user experience, stability, and new features like disk-based aggregation.

“MariaDB is one of the top relational databases in the world, known for its rapid innovation, strong community and modern architecture that supports workload flexibility,” said Max Mether, co-founder and VP of server product management, MariaDB Corporation. “We’re committed to delivering continued innovation to the community and we’re excited to deliver this year’s release packed with stunning features for both developers and DBAs.”

Innovation for the Community

MariaDB Community Server 10.6 adds major new features, including:

• Extending JSON: JSON is fast becoming the standard format for data interchange and for unstructured data, and MariaDB (in fact, all MariaDB versions 10.2 and later) includes a range of JSON supporting functions. With this release, MariaDB adds JSON table functions, enabling a table view into JSON data stored in MariaDB. Queries are returned as a regular table using SQL.
• Oracle compatibility: Beginning with version 10.3, MariaDB was the first open source database to add PL/SQL compatibility, making it easy to migrate from Oracle to MariaDB. This release adds several new community-developed PL/SQL compatibility functions, a reflection of the wide-reaching impact this open source innovation has had in the world.
• Atomic DDL: With MariaDB Community Server 10.6, Data Definition Language (DDL) is now atomic, increasing crash recovery by ensuring any DDL statement is either fully executed or not at all. Unlike MySQL, MariaDB implemented atomic DDL in the database layer so it supports various workloads using different storage engines, with immediate support for InnoDB and Aria storage engines. Atomic DDL support for other storage engines is coming soon.
• Analytics: Last year, columnar analytics was added as a supported storage engine for MariaDB, delivering analytics for all. Unlike MySQL, analytics in MariaDB is open source and can be deployed anywhere. MariaDB Community Server 10.6 includes significant enhancements to its analytical capabilities including performance improvements, additional Oracle compatibility, better resiliency and new disk-based aggregation to support larger aggregate data sets and lower hardware costs.