Relational databases lover and open source supporter. I wrote “Mastering MariaDB” in 2014, and I was a MariaDB Community Ambassador. I am an independent consultant based in London
Some Notes on 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, UPDATE). As a result, the user is able to query these tables as they appear at a point in the past, or how data evolved in a certain time range. An alternative name for this feature is temporal table, and I will use it in the rest of this text.
Read more »