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 rjbwork on Tuesday July 19, 2022 @05:08PM (#32158003)
In the past I've used MSSQL's Temporal Tables (also called System-Versioned Tables) to implement this kind of functionality. This also gets you, for free, Type 2 SCD functionality for OLAP-style queries.

I can't wait until Postgres has this kind of functionality baked in. It's such a nice feature.

[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by dgb23 on Wednesday July 20, 2022 @03:52AM (#32162761)
You likely know that there is an extension for PG that does this.
[ Parent | on HN ]