Are there any databases with built-in version control for the data itself?

Question

Database

The versioning of the data, instead of structure of tables interests. It is desirable that this be some kind of native solution that allows you to view diffs and dates of changes, as well as their authorship in specific fields and data lines. Optional: the ability to rollback all changes to a certain date / time or author.

Answer 1

No one will provide you with a diff (I haven’t even heard of it), but with recovery it’s called Point In Time Recovery (PITR). MySQL 8.0 via binary log, PostgreSQL (I suspect the same mechanism), DynamoDB.
Change auditing is generally a different plane and, as a rule, it is a rather complex mechanism that companies implement through CQRS and events, but this is generally quite far away.
In total, there is no "solution out of the box" - you need to think with your head and be able to design systems

Answer 2

MS SQL. The transaction log has all the changes. But there are no built-in viewers. There are third party applications such as SQL transaction log reader .

Answer 3

Most DBMSs have a transaction log. In addition to MS SQL, in PostgreSQL it is used to restore the state from the moment of backup to the moment of failure. In Oracle, you can see what happened, when it happened, and you can access tables from the past with regular SQL. But this mechanism has a limited view time.
Therefore it is better to solve similar not means of a DBMS.

Answer 4

I recommend dbForge Transaction Log for SQL Server It can be used to view and analyze SQL Server transaction logs and recover data from them. The tool provides detailed information about all data changes in your database and gives you the ability to undo unwanted transactions at different levels depending on your current needs.