← Back to context

Comment by hapidjus

1 month ago

Are you asking why we wouldn’t use 'last_updated' to store when the record was deleted?

One reason is that you might want to know when it was last updated before it was deleted.

4 comments

hapidjus

Reply
nottorp  1 month ago

No, more like why you'd use a more expensive filter to hide soft deleted data, instead of just a flag.

  • masklinn  1 month ago

    Checking whether `deleted_at is null` should be extremely cheap, and it avoids the duplication and desynchronisation of having both “deleted” and “deleted_at”.