DATABASES Signal 219
MariaDB 13 Expands Oracle Compatibility with REF CURSOR and RECORD Support
↗
MariaDB Community Server 13.0 has reached General Availability and introduces new features focused on Oracle compatibility and developer experience.
This update enhances compatibility for organizations using Oracle PL/SQL, facilitating smoother transitions to MariaDB. Developers gain improved tools for handling data and optimizing queries, which can lead to more efficient database management and application performance.
Written by elseif from the cluster below · every claim links back to a sourceThe three things worth knowing
MariaDB 13 introduces native support for REF CURSOR and RECORD types, improving compatibility with Oracle PL/SQL.
The RETURNING clause now allows developers to retrieve modified rows after UPDATE statements, enhancing data handling capabilities.
Query optimization improvements make it easier to use hint frameworks for complex queries, streamlining database interactions.
THE READ
What the cluster adds up to.
The release of MariaDB 13.0 marks a significant step towards improving compatibility with Oracle databases, specifically through the introduction of REF CURSOR and RECORD types. This enhancement allows developers migrating from Oracle to MariaDB to use familiar constructs, potentially reducing the learning curve and integration time for existing applications.
With the new RETURNING clause for UPDATE statements, developers can now efficiently retrieve both old and new values in a single round trip to the database. This change can lead to performance improvements by minimizing the number of database calls required to manage data modifications.
MariaDB 13 also aims to enhance observability and administration, making server configurations and metadata easier to inspect. The introduction of new system variables and improved table structures for accessing replication and storage engine details may simplify management tasks and improve automation for database administrators.
Written by elseif from the cluster below · checked for specifics the sources never containedTHE CLUSTER