Recently I talked to many companies about this topic: why a data warehouse is essential to support company decisions, in all departments. I decided to summarise my points in this article, for future reference. The need for centralised information All company...
Federico Razzoli
How to query a REST API with MariaDB CONNECT engine
Querying a remote REST API directly from the database: does it sound like pure madness? Some people will surely answer that yes, it does. So, first of all, let me spend a paragraph to show some great benefits of doing so. Then I'll show you how to query a REST API...
The benefits of MariaDB ColumnStore
Last week Richard announced our projects on MariaDB ColumnStore. Take a look at his great post, if you didn't already. Since then, I've got some questions from customers, colleagues and friends: why did you guys decide to robustly invest into ColumnStore, and offer...
Vettabase Milestones: Year 2023 in Review
2023 was a fruitful year for Vettabase Ltd, so I’ve taken some time to mark the company’s progress over the last 12 months in a blog post. I think this is also the right moment to thank everyone who crossed paths with Vettabase and contributed to its prosperity. New...
Making the case for stored procedures
MariaDB stored procedures and why they should be improved was the title of my talk at MariaDB Server Fest 2023 in Helsinki. My point was that an improved stored procedures implementation would bring benefits to individual users, the MariaDB community, and the two...
Vettabase has partnered with Bytebase!
Vettabase is pleased to announce a partnership with Bytebase, a company behind the namesake open-source database DevOps tool, a GitLab for managing databases throughout the application development lifecycle. Bytebase offers a web-based workspace for DBAs and software...
MariaDB Catalogs: some use cases
This month I attended Monty’s talk about Catalogs at MariaDB Server Fest 2023 in Helsinki. He described this nice feature, which is still under development, and how it will work. But when he talked about the use cases, I was under the impression that catalogs have...
Vettabase is now a MindsDB partner for MySQL integration
Vettabase is excited to announce a partnership with MindsDB, an AI-Automation Platform that enables the creation of the next wave of AI-centered applications. Starting from September 2023, Vettabase will help MySQL users to leverage MindsDB’s advantages and build...
MariaDB/MySQL: working with storage engines
MariaDB and MySQL support several storage engines. See MariaDB and MySQL storage engines: an overview for a discussion about existing MariaDB and MySQL storage engines. Here we'll see how to work with them. We'll see how to obtain information about storage engines,...
MariaDB and MySQL storage engines: an overview
MySQL was the first DBMS to introduce the concept of storage engines in the early 2000s. This was one of its main features. Later, MariaDB extended the storage engine API and included some storage engine maintained by third parties as part of its official...