logoalt Hacker News

hypeatei04/24/20253 repliesview on HN

Temporal tables in SQL server fit this use-case[0], I think.

0: https://learn.microsoft.com/en-us/sql/relational-databases/t...


Replies

mastax04/24/2025

Also System-Versioned Tables in MariaDB: https://mariadb.com/kb/en/system-versioned-tables/

ajuc04/24/2025

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.

show 1 reply
rjbwork04/24/2025

Available on postgres as an extension. It's a bit jank and doesn't have language integrated clauses like sql server.

show 1 reply