Google Summer of Code 2021

Good news, for you and for us: We have been approved for this year’s edition of Google Summer of Code!

What is Google Summer of Code?

Quoting https://en.wikipedia.org/wiki/Google_Summer_of_Code:

The Google Summer of Code, often abbreviated to GSoC, is an international annual program in which Google awards stipends to students who successfully complete a free and open-source software coding project during the summer. The program is open to university students aged 18 or over. It was first held from May to August 2005. 

Introducing the MariaDB Jupyter Kernel

We are proud to announce the beta release series of the MariaDB Jupyter Kernel, making MariaDB Server accessible through the popular next-generation web-based interface.

The MariaDB Kernel is ready to try out (installation, documentation, GitHub).

For all who love the easy Jupyter user interface, there is now a way to access the MariaDB Server from everyone’s favorite notebook.

The MariaDB Jupyter Kernel is as simple as it gets. It’s a “normal” MariaDB character based command line client, extended in two ways: First, it has all the standard Jupyter usability functionality for editing and saving MariaDB SELECT, INSERT, UPDATE and DELETE commands.

ARM improvements in 2020

2020 has seen quite a few developments with the ARM architecture. For MariaDB things are no different. First we have expanded our testing infrastructure to cover more Linux distributions (Debian, Ubuntu, Fedora, CentOS, RedHat) on ARM and we are now building packages for all of them. The next MariaDB release will include additional binary tarballs for ARM distributions, in addition to the already existing RPM and DEB packages.

All this could not be accomplished without the help of Huawei, who have donated several ARM builders to our effort. We strongly believe that only by testing on as many different platforms as possible, with as many different compilers as possible we can guarantee MariaDB’s performance and stability.

Thanks Tencent!

In the name of the MariaDB Foundation, I would like to thank Tencent for their significant contributions to the MariaDB Server in 2020. The permission to, and encouragement of, Tencent staff to contribute towards MariaDB shows a superior and practical understanding of the value proposition of open source in delivering value to everyone at the same time as reducing software maintenance costs.

About Tencent’s DB Kernel Team

Tencent has a cloud native database kernel R&D team, focusing on database kernel optimisation and architecture evolution. The team is experienced (over ten years of database R&D experience) and serves hundreds of thousands of enterprise users.

Making MariaDB understand MySQL JSON

Good news for MySQL users wishing to upgrade to MariaDB: MariaDB 10.5.7 onwards understands formerly-incompatible MySQL JSON fields! This blog entry explains how to install and use them.

Introducing MYSQL_JSON plugin

Starting from MariaDB 10.5.7 (commit f6549e), it is possible to upgrade from MySQL 5.7 tables containing JSON by loading the MYSQL_JSON data type plugin.

MariaDB and MySQL JSON formats are not the same. In MySQL, the JSON type is a native type, while in MariaDB JSON is just an alias for LONGTEXT. What this means in practice is that data in JSON format are not compatible with each other.

Machine Learning straight through SQL

Machine learning is one area that cannot succeed without data. Traditionally, machine learning frameworks read it from CSV files or similar data sources. This brings an interesting set of challenges because in most cases the data is stored in databases, not simple raw files. It takes time and effort to move data from one format to another. Additionally, one needs to write some code (usually python) to prepare the data just like the ML framework expects it.

I was pleasantly surprised when I saw during the MariaDB Server Fest that MindsDB, an automatic machine learning system, presented their integration with MariaDB.

A GSoC internship with the MariaDB Foundation

Introduction

Hi, my name is Kartik Soneji, and I am a second year student at Thadomal Shahani Engineering College, Mumbai. I have been programming since the age of 13. I started out with Java, then learnt a little C++ before diving head first into web development with HTML, CSS and JavaScript. I also programmed a bit in Python and Rust to see what all the hype was about.

My primary motivation to contribute to the open source community is because I strongly believe in the idea that software is free, to copy, modify and study.

Multilingual MariaDB video on Set Theory Features

Our very own Ian Gilfillan has created a brief and clear video called Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL


Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL

In a tad more than six minutes, you’ll see exactly how UNION, INTERSECT and EXCEPT work, starting in MariaDB 10.3, a few years back.

Ian explains what they are for, and the option to change default behaviour of DISTINCT with ALL (of which the ALL option was introduced in MariaDB 10.5).

That’s not new.