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.
How to compose strings in MariaDB
read more
Vettabase Blog
Read our expert blog with articles on MariaDB, MySQL, PostgreSQL, Cassandra and related tools & technologies.
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.
A summary of MariaDB 10.8: key performance improvements
New features and performance optimisations in MariaDB 10.8 short term support release.
3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.
