DATABASES Signal 288
MariaDB 13.0 Goes Stable with New SQL and InnoDB Features
↗
MariaDB 13.0 is now stable, introducing UPDATE RETURNING, improved Optimizer Trace, InnoDB log archiving, and SQL compatibility enhancements.
The stable release of MariaDB 13.0 introduces significant features that enhance database performance and usability. These improvements, particularly in query optimization and data retrieval, may streamline development workflows and reduce the complexity of certain database operations.
Written by elseif from the cluster below · every claim links back to a sourceThe three things worth knowing
The new UPDATE RETURNING feature allows for direct retrieval of modified values after single-table updates.
InnoDB now supports log archiving for improved point-in-time recovery and incremental backups.
Optimizer Trace enhancements provide insights into the statistics used for query execution plans.
THE READ
What the cluster adds up to.
MariaDB 13.0 has reached stable status with the release of version 13.0.2, which includes enhancements like the UPDATE ... RETURNING feature. This addition allows developers to directly retrieve updated values, reducing the need for subsequent SELECT statements and improving application efficiency.
The introduction of log archiving in InnoDB can significantly aid in data recovery processes. However, it's important to note that the mariadb-backup tool does not yet support this feature, which may limit its immediate utility for some users who rely on backup solutions.
Other notable improvements include the atomic CREATE OR REPLACE TABLE functionality, which simplifies table management, and the QB_NAME() hint for better query optimization. These features could lead to more efficient query execution and easier database maintenance, benefiting application performance overall.
The ongoing integration with DuckDB as a pluggable storage engine further enhances MariaDB's capabilities in handling both transactional and analytical workloads. While still classified as experimental, this feature indicates a strategic direction towards accommodating varied data processing needs in modern applications.
Overall, the release signals a commitment to improving performance and usability in MariaDB, making it a more competitive choice among open-source database solutions. Engineers should consider how these new features could be integrated into their existing systems to leverage the advancements.
Written by elseif from the cluster below · checked for specifics the sources never containedTHE CLUSTER