Author Archives: Daniel Black
There are a number of SQL Fiddles, web interfaces to databases for testing / learning SQL. Recently we noticed the versions on these falling behind and not presenting users with updates that would deliver the latest MariaDB features and bug fixes.
In reaching out to the people that manage these fiddles we’re pleased to announce that so far, two providers have updated their MariaDB version(s).
PHPize.online / SQLize.online
PHPize.online and SQLize.online are the pet projects of Slava Rozhnev. These have both been updated and now have available MariaDB 11.4, our current long term support version, and also MariaDB 11.5.
…
We launched Red Hat UBI based Docker Official Images for MariaDB! These are available on Docker Hub with tags containing ubi including lts-ubi.
The MariaDB plc folks suggested this would be good for enterprise users. After dusting of an old prototype, jointly developing the image, a couple of requests for packages into the UBI repository, and running through our test suite for compatibility testing, there is now an image available for everyone that will be maintained.
Attention to the Red Hat Open Shift Certification Policy made some compliance changes to the UBI based MariaDB image.
…
Easy question, easier answer. Docker Official Images are the official image distributor of MariaDB Server. It was years ago that the Docker Official Image of MariaDB Server gained all its environment variables in MARIADB_* form and its fork on the MariaDB Corporation Docker Hub was deprecated and eventually removed. As a result of contributing to the Docker Official Images of MariaDB Server, the day to day maintenance was transferred to the MariaDB github organization. Here, the MariaDB Foundation, with support from MariaDB Corporation (now MariaDB plc) on server and releases, continue to develop and support the Docker Official Image.
…
Continue reading “Where is the official MariaDB Container Image?”
Hi, we from the MariaDB Foundation are having a set of meetings with developers and senior managers from all over the world. We’d like your feedback on the Good/Bad/Ugly bits of MariaDB Server as you see it, and generally what we could be doing better. Please leave comments here, or Reddit, or email discuss@lists.mariadb.org (subscription), or email me directly daniel@mariadb.org.
This will be discussed at the MariaDB (Un)conference 2023 and MariaDB Server Fest 2023 which you are welcome to attend also to state your cases in person.
…
“The only workload that matters is my production workload” (for all values of “my”). So you can manage this responsibility, SCARY is a software tool which aims to take the uncertainty out of change; software, configuration and hardware changes. This is very early in development, but projects have to start somewhere.
SCARY takes a read view of the production database query execution, and does the equivalent query on a copy of the production database, that has differences. The query speed, query plan, data result (eventually) will be recorded along with what went on in production.
…
MariaDB Server 11.0 was recently released and its Docker Official Image didn’t include mysqladmin which broke the healthcheck in a few usage scenarios. This surprised some people in the change of behaviour. We have observed a number uses of the mysql names in containers, custom healthchecks and some /docker-entrypoint-initdb.d scripts. To help use these correctly, lets talk about what is available in the containers to help perform healthcheck and initialization functions.
On healthchecks, HEALTHCHECK isn’t there in Docker Official Images (for reasons), however the MariaDB Server container does have a healthcheck.sh script.
…
Continue reading “MariaDB Server Docker Official Images Healthcheck without mysqladmin”
This is the next in a series of posts on our explorations with ChatGPT that started with ChatGPT, OpenAI and MariaDB Foundation. Here, we asked ChatGPT to generate a blog post, and Chief Innovation Officer Daniel Black reviewed the results.
“Getting Started with MariaDB: A Comprehensive Guide for Beginners” is the question we asked ChatGPT. What we got is below. Rather than a blog on what you could have done yourself, I’ll look through the answer below and see how accurate it is, what could be better/worse, and assume this is some reflection on the references that the engine was trained on.
…
Continue reading “Ask ChatGPT – Getting Started with MariaDB: A Comprehensive Guide for Beginners”
As an Oracle compatibility syntax extension, the IN, OUT, and INOUT / IN OUT quantifiers of stored function parameters was requested in MDEV-10654. It was noted that Postgres and DB2 also support this syntax. A few years later thanks to our community contributor Manohar KB of Rakuten Securities Japan, this functionality was created. Alexander Barkov from the MariaDB Corporation provided reviews and extended this PL/SQL syntax to be available in the non SQL_MODE=ORACLE mode of SQL/PSM.
Having OUT parameters on functions enables the nesting of functions will multiple return values where previously there was only the single return value possible.
…
Continue reading “10.8 preview feature: IN, OUT, INOUT, IN OUT parameters in CREATE FUNCTION”