745
Lemmy.world is being "attacked" with random communities
(lemmy.world)
Welcome to Lemmy.World General!
This is a community for general discussion where you can get your bearings in the fediverse. Discuss topics & ask questions that don't seem to fit in any other community, or don't have an active community yet.
🪆 About Lemmy World
🧭 Finding Communities
Feel free to ask here or over in: !lemmy411@lemmy.ca!
Also keep an eye on:
For more involved tools to find communities to join: check out Lemmyverse and Feddit Lemmy Community Browser!
💬 Additional Discussion Focused Communities:
Rules
Remember, Lemmy World rules also apply here.
0. See: Rules for Users.
I think we might have a few GUIs for PostgreSQL, but for the most part, you're stuck trying to figure out the best way to isolate the problem communities. Unless all of the names are absurdly long or they have some other defining characteristic in common, all new communities created within a certain timeframe might need to be deleted.
Any rdbms should be able to handle it and it should be trivial to select all communities where mod_id = troll.
That's what I meant: any variable that they all have in common should be what is selected. When we were dealing with spam accounts on NormalCity, I mostly used particular patterns in the email addresses to find problem accounts. Funnily enough, some of the accounts had flat out invalid email addresses that had no .tld, and plenty had long sequences of numbers that were easy to isolate.