3 ms·
Dealing with missing user records. Deleting all records pertaining to a user, which may break a well-normalized database. Keeping track of any analysis you did
by jimktrains2 9y ago
Dealing with missing user records. Deleting all records pertaining to a user, which may break a well-normalized database. Keeping track of any analysis you did and why (e.g. scanning server logs to see country of origin to see if you may want to seek out a translation of your UI?)
- GordonS 9y agoIn practise, 'it depends'. It may be that it's simple enough to delete everything, or it may be that you anonymise, rather than actually delete. E.g. if you have a `users` table with: `id, name, email_address` You could simply blank out everything apart from `id`. Regarding logs, it might be worth thinking about whether you actually need them to contain personally identifying information (e.g. IP addresses, usernames) - if not, just don't log them.
- codedokode 9y agoJust replace deleted user's data with "Mr. Deleted 1234, 1234@deleted.com".