December 23, 2017

Announcing MariaDB Server 10.3 Beta

We are happy to announce the first beta release of MariaDB Server 10.3, the fastest growing open source relational database. Beta is an important time in our release and we encourage you to download this release today! Please note that we do not recommend running beta releases in production.

MariaDB Server 10.3 is the next evolution, after MariaDB Server 10.2 with enhancements like Window Functions, Common Table Expressions, JSON functions and CHECK constraints. For MariaDB Server 10.3 a lot of effort has been spent on database compatibility enhancements, especially for stored routines. This will allow easier migration of stored functions and better usability of stored functions in general.

Now, with MariaDB Server 10.3.3 beta, new significant features and enhancements are available for our users and customers, including:

  • Database Compatibility Enhancements
    • PL/SQL Compatibility for MariaDB Stored Functions: The server now understands a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines
    • New option for CURSOR in stored routines: A CURSOR can now have parameters used by the associated query
    • New data types for stored routines: ROW data type, TYPE OF and ROW TYPE OF anchored data types
    • Generation of unique primary keys by SEQUENCES: As an alternative to AUTO INCREMENT It is now possible to define names sequence objects to create a sequence of numeric values
    • Operations over result sets with INTERSECT and EXCEPT: In addition to the already existing UNION an intersection and subtraction of result sets is now possible
    • Define Columns to be invisible: Columns now can be defined to be invisible. There exist 3 levels of invisibility, user defined, system level and completely invisible
    • Window Function Enhancement: percentile and median window functions have been added
  • User Flexibility
    • User Defined Aggregate Functions: In addition to creating SQL functions it is now also possible to create aggregate functions
    • Lifted limitations for updates and deletes: A DELETE statement can now delete from a table used in the WHERE clause. UPDATE can be the same for source and target
  • Performance/Storage Enhancements
  • Storage Engine Enhancements
    • Spider Storage Engine: The partitioning storage engine has been updated to the newest release of the Spider Storage engine to support new Spider features including direct join support, direct update and delete, direct aggregates
    • Proxy Layer Support for MariaDB Server: Client / Server authentication via a Proxy like MariaDB MaxScale using a Server Proxy Protocol Support

Try out MariaDB Server Beta software and share your feedback

Download MariaDB Server 10.3.3 Beta

Release Notes Changelog What is MariaDB Server 10.3?

About Ralf Gebhardt

Ralf Gebhardt is Product Manager at MariaDB Corporation AB

Read all posts by Ralf Gebhardt