Comment by alkonaut
1 month ago
Can't most db systems just create a view over the data where archived_at is null, and this view is the table you use for 99% of your business needs (except auditing, undelete, ...)?
1 month ago
Can't most db systems just create a view over the data where archived_at is null, and this view is the table you use for 99% of your business needs (except auditing, undelete, ...)?
I'd go for two views - one, as you describe, that gives you the "active" records and another that gives you the "inactive" records.