Deleting a user's account

Do you think that when deleting a user’s account all his info must also be deleted from the database or keep them and set a “deleted” flag column?

What do you think?

I’m always afraid to totally lose data, so I tend to flag the record as ‘deleted’ and archive it just in case I change my mind at a later date. In small databases, this shouldn’t overload things too much.

Are you offering the possibility for users to “undelete accounts”?


probably your approach is the best solution here…just flag the deleted account.


I think if delete user account and all information about the user deleted from database but i also prepared the data to reserve a day can be used again :grin:

Another option is to set up archive tables and use INSERT SELECT to move the data and then delete from active users.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.