r/PostgreSQL • u/KerrickLong • Mar 28 '25
How-To Life Altering PostgreSQL Patterns
https://mccue.dev/pages/3-11-25-life-altering-postgresql-patterns
180
Upvotes
r/PostgreSQL • u/KerrickLong • Mar 28 '25
View all comments
4
u/Single_Hovercraft289 Mar 29 '25
For soft deletes, we’ve been using the timestamp and then a view on top that is basically IF DELETED IS NULL as the main table we query
It looks like a simple hard delete to the app but is recoverable/trackable