Regularly cleaning data will cause another problem.

If there are services in our system that depend on this data, such as a reporting system, if we clean the data and assume ID=1 or other…

分享

Regularly cleaning data will cause another problem.

If there are services in our system that depend on this data, such as a reporting system, if we clean the data and assume ID=1 or other primary key indexes, other systems may not know about it.

At this time, if we create a new data with ID=1 or other primary key indexes again, then other systems will encounter problems.

In any case, setting delete_at has its benefits, especially now when hardware is not particularly valuable,

But there are some details that we still need to carefully design.