MariaDB Server 10.3 comes with a new, very useful feature that will ease the design of many applications. Data versioning is important for several perspectives. Compliance might require that you need to store data changes. For analytical queries, you may want to look at data at a specific point in time and for auditing purposes, what changes were made, and when is important. Also, in the case of a table being deleted, it can be of great value to recover it from history. MariaDB Server now includes a feature named System-Versioned Tables, which is based on the specification in the SQL:2011 standard. It provides automatic versioning of table data.
I’ll walk through the concept of system-versioned tables with a very simple example, which will show you what it is all about. Let’s start by creating a database and a table.
No comments:
Post a Comment