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. %...
What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis.
Why autovacuum is important in PostgreSQL and how to configure it properly.
Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.
Fast-loading rows into a PostgreSQL table using the COPY FROM command.
Learn how to tune Linux parameters to improve PostgreSQL performance and reliability.
Learn how to grant or revoke rows privileges in PostgreSQL.
Optimizing read and write performance varies for every Postgres database server in a different environment.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.
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.
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most...
Our review of MariaDB 10.9 version, released in August 2022.
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.
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most...
Our review of MariaDB 10.9 version, released in August 2022.
In...
Learn how to enable an audit log plugin on the Community version of MySQL 8 Server.
Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report.
Choose the best balance between speed and consistency by setting proper consistency levels.
Cassandra 4.0 GA was released on 26th July 2021. Older versions users need to upgrade quickly.
Cassandra login fails with: “Cannot achieve consistency level LOCAL_ONE”? Let’s see why it happens, and how to solve the problem
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most...
What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis.
Why autovacuum is important in PostgreSQL and how to configure it properly.