Author: Frédéric Descamps
-
MariaDB Server 12.3 LTS Released
The MariaDB Foundation is pleased to announce the availability of MariaDB Server 12.3 LTS, the latest Long Term Support release of MariaDB Server. The first GA of the 12.3 series is 12.3.2.
MariaDB Server 12.3 LTS includes the features and improvements introduced during the MariaDB 12.x development series and provides a stable release line for production environments requiring long-term maintenance.
Highlights
MariaDB Server 12.3 LTS includes improvements across several areas of the server, including binary logging, SQL compatibility, replication, optimizer […]
-
ProxySQL joins MariaDB Foundation as Silver Sponsor
We are very pleased to welcome ProxySQL as a Silver Sponsor of the MariaDB Foundation.
ProxySQL is the leading proxy for MySQL and has recently focused on supporting more and more of MariaDB, both with the Proxy and with other open-source projects ProxySQL is stewarding, like dbdeployer and orchestrator.
I had the chance to interview René Cannaò, CEO of ProxySQL.
Why is it important for ProxySQL to sponsor an organization like the MariaDB Foundation?
ProxySQL was born within the MySQL […]
-
Adding a New Data Type to MariaDB with Type_handler – Part 5
We are concluding our series related to new data types using the Type_handler framework, with some limitations that are not yet covered by the framework:
It would have been handy for our MONEY datatype to have the possibility to define, for example, the currency to show. Or the format to have something like this:
Unfortunately, we can’t create new field attributes for our data type. As you probably already know, a column has an extra attribute called COMMENT. We can […]
-
Adding a New Data Type to MariaDB with Type_handler – Part 4
This is part 4 of a series related to extending MariaDB with a custom data type using the Type_handler framework.
You can find the previous articles below:
Overriding Existing Types
In the previous examples, our MONEY data type inherits from DOUBLE and then we override some methods.
But all the methods of every type cannot be overridden. For example, if we would like to change how the money column is sorted, we would have to override the Field_double::sort_string() method. But […]
-
Long live to dbdeployer!
As you know, MySQL-Sandbox and then dbdeployer have always been part of the Swiss Army knife for DBAs trying to evaluate, test, or reproduce issues with a certain version of their database.
The author, Giuseppe Maxia, aka the datacharmer, produced incredible work on these two projects. Unfortunately, Giuseppe decided to archive the project in 2023. Read the announcement.
But finally, someone has decided to take up the torch. ProxySQL announced this big decision last month.
We at the MariaDB Foundation […]
-
Adding a New Data Type to MariaDB with Type_handler – Part 3
In the previous article, we wrote, compiled, and tested our first custom data type for MariaDB using the Type_handler framework.
But currently, aside from allowing the use of its new name (MONEY) and listing it in the metadata, our new data type behaves exactly like a DOUBLE, the class it inherits from.
In this article, we will extend our data type just a bit by transforming the result into a VARCHAR and adding a currency sign to it: the dollar […]
-
Adding a New Data Type to MariaDB with Type_handler – Part 2
After having discovered the Type_hander framework and learned how to build MariaDB Server from source, it’s time to code our first data type!
We will create a MariaDB plugin that registers a new MONEY type and instantiates a custom field object.
Our component won’t be exciting, but we want to understand how to use the framework and test it.
We want to prove that
Everything else comes later.
Step 1: start with a minimal build file
The very first step […]
-
Adding a New Data Type to MariaDB with Type_handler – Part 1
This is the first part of the series about how to add a new data type to MariaDB using the Type_handler framework. A preliminary article has already been published to start the series; it covers how to set up your development environment and compile MariaDB Server: Adding a New Data Type to MariaDB with Type_handler – Part 0.
Understand Type_handler Before Writing Code
When you add a new type to MariaDB, you are not only adding a new SQL keyword. […]