How to version data in database?

Question

Python

There are reports, the data in which is taken from the database. There was a need for versioning. That is, when adding or deleting a record, the version of the next report must change. Are there any best practices for this? Technologies on the project - Flask, SQLalhimy, Alembic

Answer 1

It is desirable to store different versions of records.

Yes, these are the temporal features of the SQL:2011 standard .
Support in DB2 .
Support in SQL Server 2016 .
What DBMS do you have?

Answer 2

https://habr.com/post/330662/
https://habr.com/post/101544/