News for hackers. Stuff that matters.

A comment on Soft deletion probably isn't worth it. Parent comment

Re:Soft deletion probably isn't worth it by remus on Wednesday July 20, 2022 @02:50AM (#32162379)
MS SQL Server has a fun feature called temporal tables that does some of this https://docs.microsoft.com/en-us/sql/relational-databases/ta...
[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by jrumbut on Wednesday July 20, 2022 @03:18AM (#32162556)
This is very interesting!

I haven't used this feature, is it possible to twist this to find a time associated with a table state so that you can then query the table at that time (allowing you to answer a question like what was the value of X the last time Y was true)?

[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by namibj on Wednesday July 20, 2022 @11:32PM (#32175451)
You could replay the change feed from CRDB into Materialize and catch the timestamp (s) at which some query results pop out, using an incremental query in what is basically a linear search.
[ Parent | on HN ]