45
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 12 Jul 2023
45 points (94.1% liked)
17481 readers
1591 users here now
News and Discussions about Reddit
Welcome to !reddit. This is a community for all news and discussions about Reddit.
The rules for posting and commenting, besides the rules defined here for lemmy.world, are as follows:
Rules
Rule 1- No brigading.
**You may not encourage brigading any communities or subreddits in any way. **
YSKs are about self-improvement on how to do things.
Rule 2- No illegal or NSFW or gore content.
**No illegal or NSFW or gore content. **
Rule 3- Do not seek mental, medical and professional help here.
Do not seek mental, medical and professional help here. Breaking this rule will not get you or your post removed, but it will put you at risk, and possibly in danger.
Rule 4- No self promotion or upvote-farming of any kind.
That's it.
Rule 5- No baiting or sealioning or promoting an agenda.
Posts and comments which, instead of being of an innocuous nature, are specifically intended (based on reports and in the opinion of our crack moderation team) to bait users into ideological wars on charged political topics will be removed and the authors warned - or banned - depending on severity.
Rule 6- Regarding META posts.
Provided it is about the community itself, you may post non-Reddit posts using the [META] tag on your post title.
Rule 7- You can't harass or disturb other members.
If you vocally harass or discriminate against any individual member, you will be removed.
Likewise, if you are a member, sympathiser or a resemblant of a movement that is known to largely hate, mock, discriminate against, and/or want to take lives of a group of people, and you were provably vocal about your hate, then you will be banned on sight.
Rule 8- All comments should try to stay relevant to their parent content.
Rule 9- Reposts from other platforms are not allowed.
Let everyone have their own content.
:::spoiler Rule 10- Majority of bots aren't allowed to participate here.
founded 1 year ago
MODERATORS
Comments cannot be deleted at all. You can replace their content with empty text, but there will still be comments. No one in their same mind will delete anything from a production database, that's a big no-no.
… that violates the law
What makes you think nobody in their sane mind would delete anything from a production database?
That doesn't violate anything, I have GDPR training.
The data is never deleted because that will destroy the database. Your comment is not just a comment, it's also part of the indices which take forever to rebuild on delete, part of relations which will break, and also you can't just remove portion of a file on disc when this file is many gigabytes big and is accessed in read and write modes simultaneously by millions of people each second.
Not a single developer worth their salt will ever delete anything.
This is bullshit.
A DBMS (database management system) handles all the necessary file file synchronisation necessary for simultaneous reading and writing. It's a layer on top. File access sharing does not matter.
On a file you can write data in-place - without having to change surrounding data. You can clear existing data without the need to free the space it used.
Foreign keys in DBMS prevent relations from breaking.
How viable or costly data deletion or removal is greatly depends on your DBMS/storage system and usage pattern. Do you know how Reddit stores their data?
Data may be marked for deletion and regularly be deleted and indices rebuilt. Or it may keep deleted-marked content but clear its data. Both are viable and effectively data deletion. A record that holds no more of its data is no longer the data it was before.
Have you ever done any development or are you just taking random nonsense? Oh man...
My role is Lead Developer. So yes.
What's your background?
Just some 20 years of software development. Yeah, if you delete data from DB, you're not a lead, sorry. I wouldn't hire you above junior, mate.