``` UPDATE subreddits SET is_private = FALSE WHERE is_private = TRUE AND updated_at BETWEEN 2023-06-11 AND 2023-06-12; ```
Bonus: Run it every hour
I'd also worry that if Reddit moved in that direction, the mods would feel like they didn't have control over their own subs and bail. I don't believe that Reddit can afford that, especially given how many subs and what %age of the user base we're talking about here.
I guess that depends on how many people are willing to risk prison just because they're mad at Reddit. Or on what automatic moderation capabilities Reddit has. Not a moderator, so I honestly don't know how much work it does or doesn't take. They probably count on volunteer mods to filter spam and whatnot, but for legal compliance? Highly doubtful.
I'm not a mod, but I have several friends who are, and you wouldn't believe the sheer amount of gross nonsense they have to sift through. Even ignoring the relatively banal death threats, there are always questionable elements trying to sell drugs (both Rx and other), running scams, offering malware, and worse.
