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).
Thank you for the many submissions to our Call for Papers, and to your insightful replies to our Call for Attendees.
Based on the CfA replies and other feedback given to us, we could draw a few conclusions.
Attendees: Three-day event
First, we will spread out the event from a two-day event to a three-day event, for the attendees. We received several comments around preferences for shorter days, giving time for “normal” work. Rather three short days, than two long ones. That made perfect sense to us. We already changed a couple of convetions when moving from a physical event to a virtual;
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.
Join our Online Conference in September! In three different time zones, we will meet users of MariaDB Server for two packed days of presentations, interactions and insights.
The Call for Papers is open. And we have a favour to ask everyone considering attending: Please fill in our Call for Attendance survey! We need your help to ensure that we do logistics right when it comes to timing and formats, that we cover all topics that interest you, and that we prepare interactivity and tools in the best possible way.
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:
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.
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;
Requiescat in pace. May MariaDB 5.5 rest in peace!
As the maintenance policy of the MariaDB Foundation states, we are committed to maintaining each release for 5 years. MariaDB 5.5 was announced for General Availability on 11 April 2012, so EOL was originally on 11 April 2017. At that point, we extended it by three years, due to its widespread usage in distributions.
Today, we have 11 April 2020, so this is no accidental, sudden death. Everyone could see it coming.
One Final Release MariaDB 5.5.68
However, we have decided to build one final release MariaDB 5.5.68, with remaining security updates.
