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: [email protected]!
Also keep an eye on:
For more involved tools to find communities to join: check out Lemmyverse!
π¬ Additional Discussion Focused Communities:
Rules
Remember, Lemmy World rules also apply here.
0. See: Rules for Users.
@LMAO is flooding the site with random communities because they're salty about being banned for claiming too many community names. They claim they're trying to "fuck your entire site up" but I imagine it's a relatively quick fix to delete all the communities they're creating, LMAO.
drop * from communities where creator == @lmao
And, we presume, ban the originating IP. This doesn't seem like a sophisticated attack so it's probably just a single account rather than an IP hopping VPN user. Sucks that Ruud has to play whack-a-mole (whack-a-lemming?) with this idiot.
@[email protected] I'm sure you're tremendously busy already, just want to make sure you're aware of this.
It's kind of like watching a regime change in real time. Mass movement, infrastructure scaling (mostly) JIT...
How don't these fuckwits realize this place doesn't want them? Stay over in the trash heap where you belong.
What a loser, LMAO
Itβs u/spez!!
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.
As someone who's new to lemmy, could someone explain who is in charge of policing and moderating community names like this? With reddit it's obv Admins but who has that level of power here?
The instance owner/admins are in charge of that. They're kind of equivalent to the Reddit admins, except if you don't like the instance admins you can go to a different Lemmy instance but you can't move to a new Reddit instance. Also, community names are unique to each instance, so [email protected] and [email protected] share the same name but are two separate communities in two separate instances.
Why even delete those communities? Just let'em have their three megabytes of database space that gets never used and be done with it.
A simple captcha for community creation would prevent this
I feel like the little "write why" box that some instances have for account creation would be well fit for this. But for creating communities, or atleast for big instances to keep them from having tons of ghost communities.
If you're explicitly spamming, you'd just put garbage in the 'why' box as well.
Right. Effectively you DOS the site admins this way, making it hard for actual community set up.
But if you combine it with rate limiting, email verification, and a captcha, maybe it can be slowed to a manageable crawl.