There Are 10 Types of People in the World....
As a DBA, disk space has always worried me. In fact, the biggest problem for a MySQL/MariaDB DBA is the large, fragmented InnoDB Tablespaces. It was even more problematic when a single tablespace handled everything. But even with a tablespace per table (innodb_file_per_table=ON) fragmentation on large tables can still be an issue and waste disk […]
MariaDB 13.1 introduces the long-awaited `->` and `->>` JSON operators, together with `FORMAT JSON` support in `JSON_TABLE()`. Discover how these improvements simplify JSON queries, preserve nested objects and arrays, and improve compatibility with MySQL applications.
When we talk about extending a database server, we usually think about features that could benefit a very large number of users. A new authentication mechanism, a storage engine, an audit plugin, a new generic data type such as UUID or INET, additional JSON functions… these are relatively easy to justify because their potential audience […]
Names are important. They help us identify people, projects, products, pets, database servers, and occasionally the correct bug tracker. This may sound obvious, but the database world has spent more than fifteen years proving that it is not. MySQL and MariaDB share a substantial amount of history, syntax, tooling, knowledge, applications, and community. They also […]
Reversing Transactions Directly from the Binary Log Some ideas never completely disappear. They remain somewhere in your brain, waiting for the right opportunity—or the right API—to come back. For me, recovering rows from the binary log is one of those ideas. More than ten years ago, I started experimenting with a simple question: If row-based […]
Have you ever modified a MariaDB configuration file, restarted the service, and immediately regretted it? You wanted to change: but accidentally wrote: One missing letter. That is enough to turn a perfectly healthy database server into a service that refuses to start. And of course, this kind of mistake never happens during a quiet maintenance […]
As you may already know, there are many places where a MariaDB system variable can get its value. It can come from: And when several configuration files are involved, finding the effective source is not always obvious. Fortunately, MariaDB provides this information in INFORMATION_SCHEMA.SYSTEM_VARIABLES. Let’s check this in action with max_connections. Checking the current value […]
Apache Arrow Database Connectivity (ADBC) provides a standard interface for exchanging data between applications and databases using Apache Arrow. You can think of it as an Arrow-oriented alternative to traditional database APIs such as ODBC and JDBC. The important difference is that ADBC is designed around columnar data. Query results are returned as streams of […]
Firefox has had native Tab Groups (since version 141) to help organize your browsing… and I love this feature! However, what a disappointment when I realized that once Firefox closed, the groups were lost! But hey, this is open source, isn’t it? And Firefox easily supports extensions, so I am happy to announce lefred’s GroupKeep […]
You may have recently seen that MariaDB Server supports the DuckDB Storage Engine [1][2]. And that’s great. After my first look at it, Roman created those 3 MDEVs with my suggestions: And he started working on it! If we also check the roadmap, we can see that the DuckDB Engine will bring support for the […]