MariaDB has launched a preview version of its latest iteration, MariaDB 12.2, showcasing a range of new features and enhancements aimed at improving user experience and database functionality. This update includes compatibility features such as the TO_NUMBER() function for converting character strings to numerical values, the TRUNC() function for enhanced data manipulation, and the introduction of global temporary tables for session-based data management.
In addition, the update significantly improves replication capabilities, allowing for replication between tables with varying structures, which enhances the database's usability and flexibility. Optimizer hints have also been introduced to help users optimize query performance by providing more control over rowid filtering and index merge operations.
MariaDB 12.2 also includes improvements in the INFORMATION_SCHEMA table, offering additional information such as a TRIGGERED_UPDATE_COLUMNS column and a PARAMETERS column with a PARAMETER_DEFAULT field for storing default parameter values. The new version is designed to support advanced clustering via Galera Cluster 4 and offers compatibility features for Oracle Database and Temporal Data Tables, allowing users to query historical data effectively.
This release marks a significant evolution in MariaDB's journey as it adopts a rolling release model, reflecting its commitment to ongoing innovation and adaptability to user needs. As an open-source relational database, MariaDB continues to thrive, maintaining its standing as the default choice in many cloud offerings and Linux distributions.
Overall, MariaDB 12.2 represents a substantial advancement in open-source database technology, providing users with enhanced features, improved performance, and a commitment to openness and innovation that makes it a compelling choice for data management.
As the preview becomes available, users are encouraged to explore the new features and provide feedback to help shape future iterations of MariaDB. The community's involvement will further enhance its functionality and ensure it meets the diverse needs of its user base
In addition, the update significantly improves replication capabilities, allowing for replication between tables with varying structures, which enhances the database's usability and flexibility. Optimizer hints have also been introduced to help users optimize query performance by providing more control over rowid filtering and index merge operations.
MariaDB 12.2 also includes improvements in the INFORMATION_SCHEMA table, offering additional information such as a TRIGGERED_UPDATE_COLUMNS column and a PARAMETERS column with a PARAMETER_DEFAULT field for storing default parameter values. The new version is designed to support advanced clustering via Galera Cluster 4 and offers compatibility features for Oracle Database and Temporal Data Tables, allowing users to query historical data effectively.
This release marks a significant evolution in MariaDB's journey as it adopts a rolling release model, reflecting its commitment to ongoing innovation and adaptability to user needs. As an open-source relational database, MariaDB continues to thrive, maintaining its standing as the default choice in many cloud offerings and Linux distributions.
Overall, MariaDB 12.2 represents a substantial advancement in open-source database technology, providing users with enhanced features, improved performance, and a commitment to openness and innovation that makes it a compelling choice for data management.
As the preview becomes available, users are encouraged to explore the new features and provide feedback to help shape future iterations of MariaDB. The community's involvement will further enhance its functionality and ensure it meets the diverse needs of its user base
MariaDB 12.2 Preview released
MariaDB 12.2, a preview version of the popular open-source relational database, introduces several new features and improvements to its functionality. The update includes compatibility features such as the TO_NUMBER() function, TRUNC() function, global temporary tables, and enhanced replication capabilities between tables with different structures. Additionally, MariaDB 12.2 offers improved optimizer hints for query performance optimization and additional information in the INFORMATION_SCHEMA table for better database management.
