Category Archives: Development
August may have been a holiday month for many, but the MariaDB community certainly didn’t take a break. From Amsterdam to Bengaluru, from deep technical dives to festive dinners, August brought us fresh insights, new collaborations, and plenty of reasons to be excited about the road ahead.
Community Interaction at Linux Foundation’s Open Source Summit in Amsterdam
MariaDB Foundation proudly joined the Open Source Summit in Amsterdam, hosted by the Linux Foundation (LF OSS). Alongside me, Vlad Radu represented the Foundation at our booth – joined by none other than Michael “Monty” Widenius (founder of both MariaDB and MySQL) and Sergei Golubchik (Chief Architect of MariaDB Server).
…
Continue reading “This Month in MariaDB Foundation: August 2025”
Earlier I posted that this presentation was about to happen, and it did! I presented to a keen audience of over 20 people live, and number who watched later (it was in a rather early US time, however attracted a number of attendees from Europe, India, Thailand all the way to east of Australia at UTC+10:30.
Below is the video, and the slide outline is available.
The journey to this presentation began as a request to update our Clang version that we use in Buildbot, MariaDB’s CI system.
…
Continue reading “Deep dive into Clang sanitizer testing with MariaDB (Post Event)”
That’s the question every tester dreads to hear, because it usually means we’ve let something really embarrassing slip into a release.
The real answer is, “Yes, we do,” though that doesn’t offer much comfort if you’re facing issues in production. Still, during quieter moments, people sometimes ask less rhetorically what kind of testing takes place in MariaDB. Let’s dive into that.
A path of a bugfix into a maintenance release
When a pull request (or an internal patch outside the PR system) is pushed into the MariaDB/server repository on Github, it is picked by the MariaDB server CI, Buildbot.
…
For historical reasons, the handling of FOREIGN KEY constraints in MariaDB Server is somewhat peculiar. Unlike CHECK constraints, which are being enforced at the query execution layer for all tables, FOREIGN KEY constraint definitions will simply be ignored unless the underlying storage engine supports them.
The storage engine is not only responsible for enforcing referential integrity between tables, but also storing the constraint definitions. Currently, InnoDB is the only storage engine that supports foreign key constraints, between persistent, non-partitioned tables.
Partitioning is implemented by a storage engine wrapper that makes each partition or subpartition appear as a separate table in the underlying storage engine.
…
Continue reading “Per-table unique FOREIGN KEY constraint names – new feature in MariaDB 12.1”
At some point, nearly every developer encounters a common challenge: working with deeply nested JSON only to run into an arbitrary depth limit imposed by the database. In our case, that hard cap was set at 32 levels — sufficient for many scenarios but too restrictive for more complex or dynamic data structures. To address this, we decided to remove the limitation entirely.
The database now supports JSON documents and JSON paths with virtually unlimited nesting! This change unlocks the ability to work with more flexible and expressive data models without forcing developers to restructure or flatten their data.
…
Continue reading “Make JSON DEPTH unlimited – new feature in MariaDB 12.1”
We continue our blog series on learning more about users of MariaDB. Searching LinkedIn for posts about MariaDB this morning we saw an impressive confident post about using MariaDB in a RAG solution named SemantiQ. We got curious about it and reached out to the author Lorenzo Cremonese to have a chat.
Tell us about yourself Lorenzo!
I’m an Italian studying in Spain. I began programming when I was 14, and I’m now 22. I’m a self-taught web developer since 3-4 years ago, and I’m now doing a two year University education in Spain focused on web development at the institute IES ENRIC VALOR, in Pego.
…
Continue reading “Can you do RAG with Full Text Search in MariaDB?”
Now is a good time to upgrade to the freshest MariaDB Server. MariaDB 11.8 is the yearly long term support release for 2025. It’s the first LTS with support for MariaDB Vector, and it includes a number of other updates based on user requests. You can seamlessly upgrade to MariaDB 11.8 from MariaDB 11.4 (the previous LTS) or any older release, back to MariaDB Server 10.0 or earlier, including most versions of MySQL Server.
MariaDB 11.8 LTS includes everything added since 11.4, incorporating changes from 11.5, 11.6, 11.7, as well as new features not released before.
…
Last week we announced the winners of the MariaDB AI RAG hackathon that we organized together with the Helsinki Python meetup group. Now is time to go for a deep dive into the innovation track winner. Dymtro Abramov put together an end to end RAG application for making technical meetup videos searchable with semantic relevance (based on their caption texts). We were impressed by the idea and the implementation that is definitely beyond just a proof of concept for AI RAG with MariaDB Vector.
Dmytro, tell us about yourself and why you decided to join the Hackathon?
…