7 ms·
As someone who’s been doing a lot of database design lately, how does everyone plan to handle referential integrity if laws like this become more commonplace or
by CSSer 3y ago
As someone who’s been doing a lot of database design lately, how does everyone plan to handle referential integrity if laws like this become more commonplace or widely applicable?
Is it silly to suggest that laws like these could make cascade on delete a whole lot more commonplace?
- rzmmm 3y agoIn GDPR it's sufficient to anonymize the data. That is sometimes easier for data integrity.
- mycall 3y agoThanks for the tip, I'll use this for our company's needs.
- andersa 3y agoIsn't the common practice to just replace the personal data in the db with garbage and otherwise leave the records in place - i.e. to prevent accidental reuse of the ids which could have unforseen consequences? If their user now brings up "deleted user 12345", you've done your job and deleted the data they cared about.
- immibis 3y agoDon't ask the question about database systems. Ask the question about data. Instead of asking "how can rows in my posts table reference a deleted row in the users table?" ask "how can I show posts by deleted users?" And that's a business requirement. Either you delete the post, or you delete the post's author link, or you delete the post's author link and content. Find out which one, and design and implement it.
- immibis 3y agoor you retain the author link but scrub all useful information from the author record