Time Travel with MariaDB: Exploring Temporal Tables
Abstract
Temporal tables have been around since MariaDB 10.3. They provide some great functionality, but are not as widely-known as they should be.
System-versioned tables store the history of all changes to a table. Accidentally deleted some data? No need to rush for the backup, it’s still accessible on the running server!
Application-time periods extend system-versioned tables, allowing one to add two columns defining a time range, and a constraint to check whether the first value is less than the second value.
This talk covers some of the basics of using these in your applications.