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)?
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.
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)?