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).
The MariaDB Server Fest is approaching fast and registration is now open. We’ve been busy fine tuning things according to the input we got during the Call for Attendance, as well as selecting the final talks.
We have an excellent series of sessions lined up. Whether you’re interested in best practices, migration, new features, use cases, or the latest on hardware innovations and MariaDB, there’ll be something for you when it kicks off on 14 September.
It’s been close to four months since we announced our new project of renewing MariaDB Downloads. We are now ready to launch our first version. We have done a lot of work behind the scenes which will simplify further developments. A technical breakdown post is coming, but for now, let’s focus on the new features!
In with the new
User friendliness – one click to download
New downloads form
User friendliness is at the core of MariaDB (going all the way back to MySQL times). It should be really easy to download, install and run MariaDB.
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:
