Buy Percona ServicesBuy Now!

Some Notes on MariaDB system-versioned Tables

 | December 14, 2018 |  Posted In: MariaDB, MySQL

mariadb system-versioned tables

As mentioned in a previous post, I gave a talk at Percona Live Europe 2018 about system-versioned tables. This is a new MariaDB 10.3 feature, which consists of preserving old versions of a table rows. Each version has two timestamps that indicate the start (INSERT,UPDATE) of the validity of that version, and its end (DELETE, […]

Read More

Percona Live Europe Presents: MariaDB System-Versioned Tables

 | October 17, 2018 |  Posted In: Events, MariaDB, MySQL

PLE Frankfurt Logo

System-versioned tables, or temporal tables, are a typical feature of proprietary database management systems like DB2, Oracle and SQL Server. They also appeared at some point in PostgreSQL, but only as an extension; and also in CockroachDB, but in a somewhat limited fashion. The MariaDB® implementation is the first appearance of temporal tables in the MySQL […]

Read More