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.

Read more

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.

Read more

Selecting the right database

How do you select a database in practice? How do you pretend to select it? And, if you want to be serious, how do you select it logically?

Those are the key questions I dug into, during my keynote last week at Percona Live Online.


For those who feel they don’t want to listen to the entire 30 minute video of the presentation, I have compiled a number of entry points for you below:

  • 0:23 Silly hat meme, “Teknologmössa”
  • 2:19 Agenda
  • 2:43 Choosing a database in practice
  • 3:59 Pretending to choose a database
  • 5:00 Triggers for making a fresh choice
  • 5:51 Monetary impulses
  • 7:53 Database lifecycle impulses
  • 10:07 MariaDB 5.5 on Github
  • 11:24 Framework for database choice: 1.

Read more

MariaDB Academy: Authentication from MariaDB 10.4, and Account Locking and Password Expiry

This week sees the release of Authentication from MariaDB 10.4 on the MariaDB Foundation YouTube channel.

The latest in the series of video tutorials, it provides an overview of what’s changed with authentication from MariaDB 10.4, and looks in particular at unix_socket authentication. Although you’ll hopefully no longer need it, in case you have reverted to the old password authentication model, there’s the ubiqutous “how to restore access if you’ve lost your password” tutorial as well.

Continuing the MariaDB 10.4 theme, last week saw the release of Account Locking and Password Expiry by MariaDB Foundation software developer Robert Bindar. Read more

MariaDB Academy: NoSQL in MariaDB – JSON support.

Last week, MariaDB Foundation CEO Kaj Arnö asked how MariaDB can help you create great applications, and the first in what is sure to be many attempts to answer that was released today with Senior Software Developer and Team Lead Vicențiu Ciorbaru’s new video titled NoSQL in MariaDB – JSON support.

Demonstrating the primary JSON functions, JSON_VALID, JSON_COMPACT, JSON_DETAILED, JSON_INSERT, JSON_REPLACE, JSON_REMOVE and JSON_EXTRACT, Vicențiu covers the basics of MariaDB’s JSON functionality, culminating in a game data structure that sees footmen and peasant take on grunts in a human vs computer showdown.

View NoSQL in MariaDB – JSON support on MariaDB Foundation’s YouTube channel. Read more

Pick your feature!

With many of us spending lots of time at home in front of our webcams, MariaDB Foundation’s YouTube channel is getting some love. After lurking quietly after registration, we’ve kickstarted it recently by uploading all presentations from the recent MariaDB Day, held in Brussels in February.

MariaDB Foundation’s CEO, Kaj Arnö, put together Hi from Kaj (the rhyming should help clarify confusion on how to pronounce his name) where he asks for feedback on which video topics you’d like to see us tackle.

For now we’re focusing on features already available in MariaDB, not features. Read more