Hi folks, what is the general consensus on the soft

Question

Hi folks, what is the general consensus on the soft

delete approach? Option one is to go with the 'deletedAt' and filter "where deletedAt is NULL", option two would be to go with the flag approach, adding designated column 'isDeleted' and have a partial index on it. I`ve seen both, like the latter one better, but definitely opened to any opinions

#programming #russian

0

вчера 23:21

1 ответов

1 просмотр

Stefanie Janine Stölting · Accepted Answer

Stefanie Janine Stölting

When you already have a timestamp handling when a record has been changed, I would go for the boolean. And personally I dislike handling NULL as values as it is by definition the absence of value.

0

11 часов назад

169 похожих чатов

Hi folks, what is the general consensus on the soft

1 ответов

Похожие вопросы