In my first post in 2023, I want to give you a summary of MariaDB 10.10. Some may argue that I'm a bit late because it was released last November, and versions 10.11 and 11.0 have been announced...
Vettabase Blog
Read our expert blog with articles on MariaDB, MySQL, PostgreSQL, Cassandra and related tools & technologies.
Cassandra: How to run a query with Maximum Consistency
Cassandra consistency levels are a tricky concept, until you familiarise with them. They’re based on a simple consideration: not all data and not all queries require the same level of correctness.
How to compose strings in MariaDB
MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren’t familiar to you. This article covers all the ways to compose strings.
Hints to optimise queries with a LIKE comparison
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most use cases, thanks to its two jolly characters: _ means any one character. %...
A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more
Our review of MariaDB 10.9 version, released in August 2022.
How to set up AWS Audit Log plugin for MySQL 8 Community
Learn how to enable an audit log plugin on the Community version of MySQL 8 Server.
AlloyDB versus PostgreSQL: a performance review
What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis.
Deploying an Ansible role on a Vagrant machine
Learn how to deploy Ansible roles on a Vagrant machine, possibly using the same roles that are used in production.