Other Databases

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

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.

Services



Database Automation



Database Training



Database Health Check



Monthly DBA Time



Database Upgrade

A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more

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

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.

A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more

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

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

Hints to optimise queries with a LIKE comparison

In...

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

Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report.

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.

Choosing Cassandra consistency levels wisely

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

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.

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

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

Tuning PostgreSQL Auto-vacuum

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

Email

Schedule Meeting

Phone

Other Databases

NULL comparisons in MariaDB, PostgreSQL, and SQLite

First impressions about immudb, the immutable database

Categories

Services

Database Automation

Database Training

Database Health Check

Monthly DBA Time

Database Upgrade

Email

Schedule Meeting

Phone

Quick Links

Recent Posts

A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more

Cassandra: How to run a query with Maximum Consistency

How to compose strings in MariaDB

Policies & Licenses

Follow Us on Social Media

A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more

Cassandra: How to run a query with Maximum Consistency

How to compose strings in MariaDB

A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more

How to compose strings in MariaDB

Hints to optimise queries with a LIKE comparison

Hints to optimise queries with a LIKE comparison

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

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

Cassandra: How to run a query with Maximum Consistency

Choosing Cassandra consistency levels wisely

ALERT: Many Cassandra users may need an urgent upgrade

Hints to optimise queries with a LIKE comparison

AlloyDB versus PostgreSQL: a performance review

Tuning PostgreSQL Auto-vacuum