ColumnStore Native Part of MariaDB 10.5

On Wednesday 24 June 2020, MariaDB Server 10.5 was released GA. While there are several cool new features included, this first 10.5 blog is about the groundbreaking new component, ColumnStore.

The big picture

ColumnStore brings data warehousing to the world of MariaDB Server. It’s a columnar storage engine (Wikipedia: Column-oriented DBMS), enabling what is often called HTAP (Wikipedia: Hybrid Transactional/Analytical Processing). The Columnar data type stores data by columns, not by rows, enabling quick analytical reporting over huge data volumes.

The news

The ColumnStore engine is part of MariaDB Server 10.5.

Read more

Congratulations, MySQL, 25 years today!

Time flies!

It certainly doesn’t feel like 25 years ago that Monty released MySQL. At that time, I thought it was a bit redundant of Monty to create Yet Another Database, the world was full of them already. But MySQL turned out to become the database for Internet, growing hand-in-hand with PHP (and Perl and Python). 

When MySQL was created 1995, Monty’s oldest daughter My was six years old. When the first MariaDB was released 2009, My’s little sister Maria was one year younger, five years old.

The oldest mysql.com site I found: 5 July 1998

One innovation over the other databases was the license model.

Read more

Planet MariaDB underwent liberal facelift

Planet MariaDB has been reworked from scratch, getting a new instance with the same look and feel as the rest of mariadb.org.

Three news items, related to that: One bad, one neutral, one good. I’m saving the good one for last, as I hope you will like it.

Bad news: The old Planet had five different RSS feeds, we now have only one. We maintain the format changes only on one RSS feed, which means that some of you will have to update your RSS feed to https://mariadb.org/planet-feed.xml (also listed on Planet MariaDB). That said, we are working on further redirects;

Read more

A different kind of tech conference

Last Wednesday, I received an unexpected text: “Would you like to do some volunteering work? It involves speaking online to some kids for one hour about IT”. It was a classmate from high school.

MariaDB Foundation employees work remotely. Sure, we all meet together in one place a number of times a year so we don’t forget each other’s faces, but in 99% of our logged time, we are distributed around the globe. We are also not required to have a strict working schedule and this offers us the opportunity to say yes easily to these sort of events.

Read more

Join the Solstice Run Sat 20 June 2020

My favourite running track is full! Full of newbie runners, young and old. Mostly running alone, sometimes in pairs – but all following social distancing. 

Social distancing can be coupled with emotional closeness. That’s at least what Sauli Niinistö propagates, the President of Finland. In line with these two phenomena – emotional closeness between isolated colleagues, and the boom of running as a source of energy during lockdown – we are launching the Solstice Run

We want to inspire non-runners to run

As initiators, we want to inspire others to start running.

Read more

Heads up: Renewing MariaDB Downloads

Time to renew downloads.mariadb.org! We are embarking on a long project. A large part of our user base mainly interacts with us through downloading new versions. Renewing MariaDB Downloads is the biggest-impact project of all of 2020, for that part of our user base.

Projects like this often get launched when external and internal impulses coincide. Our users have asked for a more consistent, simpler user experience. Advanced users would like a programmatic interface (a.k.a. REST API) for part of the functionality. And the current codebase needs refactoring attention, as it has served past its best-before date.

Read more

Business As Unusual

MariaDB Foundation faces an unusual world, just like anyone else in these Corona times. Or perhaps, not quite. Here are some ideas for how to cope with a world inhibiting travel and social contact as we know it, from someone who has worked from home for 20 years, with colleagues also working from home.

First, stay upbeat. Humans are social animals, and we live off interactions with others. But Corona just dictates what type of social interactions we can have. It doesn’t inhibit social contact.

Second, stay connected.

Read more

Migrating from SQL Server to MariaDB on the MariaDB Knowledge Base

A new series, Migrating from SQL Server to MariaDB is currently being developed on the MariaDB Knowledge Base by Federico Razolli.

Federico is a freelance database consultant, organizer of the Read more