After 6 months of development Published The first stable release of the new branch of the DBMS MariaDB 10.7 (10.7.2 ), within which a branch of MySQL develops, maintaining backward compatibility and differing in the integration of additional storage engines and extended capabilities. The development of MariaDB oversees the independent organization of MariaDB Foundation in accordance with the fully open and transparent development process, independent of individual manufacturers. MariaDB comes instead of MySQL in many Linux distributions (Rhel, Suse, Fedora, OpenSuse, Slackware, Openmandriva, Rosa, Arch Linux, Debian) and implemented in such major projects like Wikipedia, Google Cloud SQL and Nimbuzz.
At the same time, the first test release of the next significant branch of MariaDB 10.8.1 and Corrective updates 10.6.6, 10.5.14 , 10.4.23, 10.3.33 and 10.2.42. Release 10.7.2 became the first after the project transition to a new model of formation of releases, implying a reduction in support period from 5 years to 1 year and the transition to the formation of significant issues more than once a year, and once a quarter.
Key improvements mariadb 10.7 :
- added new data type uuid , designed to store 128-bit unique identifiers (Universally Unique Identifier ).
- new features for data processing in JSON format are proposed: json_equals () To compare the identity of two JSON documents and json_normalize () To bring JSON objects in a form suitable for performing comparison operations (performs sorting keys and removing spaces).
- Added function natural_sort_key () to sort rows taking into account digital values (for example, the string “V10” after sorting will take Place after string “V9”).
- Added function SFORMAT () For arbitrary rows formatting – on the input row from formatting commands and list of values for substitution (for example, ‘sformat (“The Answer Is {}.”, 42)’).
- improved error informing in Insert queries adding data to several lines ( get diagnostics now displays The Row_Number property indicating the row number with an error).
- The composition includes a new password check plugin password_reuse_check