MariaDB 10.6 Strengthens JSON
Written by Kay Ewbank   
Thursday, 24 June 2021

MariaDB Community Server 10.6 has been released with more JSON functions, extended Oracle compatibility in the form of PL/SQL, and atomic DDL supporting MariaDB's multiple storage engines to "add insurance for bad database days" according to the company. 

MariaDB began as a way to provide an alternative to MySQL when Oracle took that over, and MariaDB retains a strong open source strand as well as a commercial arm. MariaDB has a SQL interface for accessing data, alongside GIS and JSON features.

mariadb

The improvements to the new release start with the extensions to JSON. MariaDB has had JSON support since version 10.2. The new version extends the existing range of functions that can be used with JSON data, adding JSON table functions. These can be used with a SQL query and return a 'normal' table from JSON data stored in MariaDB. The table can then be worked with as a table view. 

The Oracle PL/SQL support that was added in version 10.3 has been extended with the inclusion of several PL/SQL compatibility functions that have been developed by the MariaDB community.

MariaDB's Data Definition Language (DDL) has been strengthened to be atomic, so if a crash happens any DDL statement is either fully executed or isn't carried out at all. The atomic DDL has been implemented in the database layer so will work with MariaDB's different storage engines. This version supports the InnoDB and Aria storage engines, with support for other storage engines "coming soon".

The final change of note is a strengthening of the columnar analytics storage engine that was added last year to provide a universal analytics option. The updated version has performance improvements, more Oracle compatibility, better resiliency and new disk-based aggregation. This will make it able to support larger aggregate data sets.

MariabDB Community Edition 10.6 is available now.

mariadb

More Information

MariaDB Site

Related Articles

MariaDB SkySQL Improves AWS Support

MariaDB 10.4 Reaches Release Candidate Status

MariaDB Announces Cloud Native Open Source DB

MariaDB Announces New Enterprise Server

MariaDB Adds Node.js Connector

MariaDB 10.3 Release Candidate

MariaDB Enterprise Updated

MariaDB Enterprise Spring Update

MariaDB Enterprise Updated

MariaDB Enterprise

MariaDB 10 Available

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


DenoDB Enables Wider Database Support
08/07/2021

There's an updated version of DenoDB that improves support for databases outside its main list of supported formats by allowing connections with a URL string. DenoDB is an ORM that supports the use of [ ... ]



AdoptOpen JDK Surges Ahead
13/07/2021

The 2021 Edition of the JVM Ecosystem Report is out and reports that Java 11 is now the dominant choice of JDK for both production and development, with Java 15 having a relatively strong foothold.


More News

square

 



 

Comments




or email your comment to: comments@i-programmer.info