coffeeisnotlatte

I got march of shamed once because I genuinely forgot, it somehow shortcircuits my brain when I need to wait for approval, thinking I've already paid and walk out after waiting for the person to come tap some buttons :|

Not super easily. It can be done by querying the postgresql dabase, but there is no built-in method to do it using the browser interface at the moment. When anyone from any instance does report them, you will see the report.

Do you have an example of a query I could use? I'm a bit rusty with databases :) with an example I can get chatgpt to build me something better

I see, occasionally I get reports from local users about something elsewhere from a 'foreign' user... which I can then delete. I assume that's not deleting from their server?

For example I get a report from a local user about a lemmy.ml user with a post in lemmy.world

I don't unfortunately, I deliberately don't log that due to some of the sensitive stuff on my own instance (we're China based)

Yup I've got them, luckily 5 or more repeating numbers in their email pretty much identified 99% of them. Would you like me to send the CSV somewhere? 27k+ bots

That's okay I found it, luckily there's a pattern here too... I dug up 27k with repeating numbers on emails which is a good start!

Huh adminer would definitely be an easier way to do this, do you have the part of the docker-compose you used with the env vars etc?

Yeah that's the issue I'm having, someone sent me a postgres command in DM earlier but it does seem to be a bit of a nuke/picking up ordinary users....

Yeah I started on a dinky little server and now it's massive.... mostly seems to be a memleak or something going on though that's causing OOM and a massive CPU spike. Anyone know anything? 4GB of RAM getting eaten for breakfast... just had to up it to 8

Damn, I've got to look into that myself. Mine's currently on AWS and costing me a small fortune

I just put my instance through cloudflare, it seems okay. I would guess cloudflare won't be that fussed considering it's federated/easily accessible from others.

You could, but the API for Reddit won't work in two weeks... and tbh I like the fact we're building something new here