Great article, I'd like to share some additional solution which came to my mind:
Another possible appraoch would be to create a view to apply the WHERE clause automatically, so that the deleted entries are automatically filtered when they are not used explicitely. I've already seen something similar but with a timestamp datatype, so there is additional info when the entry was deleted.
Great article, I'd like to share some additional solution which came to my mind:
Another possible appraoch would be to create a view to apply the
WHERE
clause automatically, so that the deleted entries are automatically filtered when they are not used explicitely. I've already seen something similar but with a timestamp datatype, so there is additional info when the entry was deleted.Thank you, David.
Yes, this is also a valid approach and many developers use it.