Vetta-Archived - Vettabase

SQL Savepoints and When to Use Them

Jan 22, 2026

Not many developers know about savepoints in relational databases. Even less of them know when to use them. It's not their fault: I can't remember seeing a good explanation of this feature. Let's try to clarify this lesser-known functionality. In this article I'm...

Distributed, Multi-Database Transactions Involving MariaDB and PostgreSQL

Jan 19, 2026

In some situations, an application needs to run a single logical transaction that involves multiple database technologies: in our example, they'll be MariaDB and PostgreSQL. This is not an optimal scenario and I'm not recommending to design systems in this way. But...

MariaDB Underrated Features: Zero Dates and Partial Dates

Dec 30, 2025

How do you represent information like this in a database? This event happened in 2015/06, but we don't know in which day. This job is scheduled to happen on the first day of the month at 00:00:00, every month and every year. This never happened. There are many ways to...

Email

Schedule Meeting

Phone

Special Download Ebook

MariaDB 10.1.48, glibc 2.14 or newer

Email

Schedule Meeting

Phone

Quick Links

Recent Posts

SQL Savepoints and When to Use Them

Distributed, Multi-Database Transactions Involving MariaDB and PostgreSQL

MariaDB Underrated Features: Zero Dates and Partial Dates

Policies & Licenses

Follow Us on Social Media