Comment by hypeatei
8 hours ago
Temporal tables in SQL server fit this use-case[0], I think.
0: https://learn.microsoft.com/en-us/sql/relational-databases/t...
8 hours ago
Temporal tables in SQL server fit this use-case[0], I think.
0: https://learn.microsoft.com/en-us/sql/relational-databases/t...
Also System-Versioned Tables in MariaDB: https://mariadb.com/kb/en/system-versioned-tables/
Available on postgres as an extension. It's a bit jank and doesn't have language integrated clauses like sql server.
Oracle has flashback queries (SELECT ... AS OF timestamp).
It's one of these things that are available but most people ignore it and implement it manually with created_at updated_at deleted_at columns etc. I think one reason for this is lack of support in ORMs and lack of standardization between RDBMSes.