In my recent webinar Designing a schema for a data warehouse, I was asked a question that deserves a long answer. I recommended to use IDs generated directly in the data warehouse. In other words, even if you import customer data from a MySQL database and each...
MariaDB released a new Long Term Support version as Generally Available: 11.4. So I feel it's time to resume my ongoing project of reviewing MariaDB new versions. I didn't review recent MariaDB versions, but this doesn't mean I wanted to cease my reviews. My...
At Vettabase, we're delighted to announce our new project, sponsored by MariaDB Foundation: the Awesome MariaDB list on GitHub! We already interact with the MariaDB Foundation as Technology Partners, and this project is the newest outcome of our long-time friendship....
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...
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...
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...
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...
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 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...
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...
