Other Databases

NULL comparisons in MariaDB, PostgreSQL, and SQLite

NULL comparisons in MariaDB, PostgreSQL, and SQLite

by Federico Razzoli | Sep 6, 2021 | MariaDB, MySQL, Other Databases, PostgreSQL

Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.

First impressions about immudb, the immutable database

First impressions about immudb, the immutable database

by Federico Razzoli | May 31, 2021 | Other Databases

Experiments and first impressions about immudb, the immutable SQL and K/V DBMS.

Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.

Categories

Services

Database Automation

Database Training

Database Health Check

Monthly DBA Time

Database Upgrade

How to compose strings in MariaDB

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

Hints to optimise queries with a LIKE comparison

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...

A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more

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 compose strings in MariaDB

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

Hints to optimise queries with a LIKE comparison

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...

A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more

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.

Hints to optimise queries with a LIKE comparison

Hints to optimise queries with a LIKE comparison

Hints to optimise queries with a LIKE comparison

In...

How to set up AWS Audit Log plugin for MySQL 8 Community

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.

3.6 millions MySQL servers accessible from the web. Hints to keep yours secure

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.

Choosing Cassandra consistency levels

Choosing Cassandra consistency levels

Choose the best balance between speed and consistency by setting proper consistency levels.

ALERT: Many Cassandra users may need an urgent upgrade

ALERT: Many Cassandra users may need an urgent upgrade

Cassandra 4.0 GA was released on 26th July 2021. Older versions users need to upgrade quickly.

Cassandra login error: Cannot achieve consistency level LOCAL_ONE

Cassandra login error: Cannot achieve consistency level LOCAL_ONE

Cassandra login fails with: “Cannot achieve consistency level LOCAL_ONE”? Let’s see why it happens, and how to solve the problem

Hints to optimise queries with a LIKE comparison

Hints to optimise queries with a LIKE comparison

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...

AlloyDB versus PostgreSQL: a performance review

AlloyDB versus PostgreSQL: a performance review

What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis.

Tuning PostgreSQL Auto-vacuum

Tuning PostgreSQL Auto-vacuum

Why autovacuum is important in PostgreSQL and how to configure it properly.