squiblet

joined 1 year ago
[–] [email protected] 2 points 1 year ago

Sites like reddit could have about the same problem. You can post to some obscure profile and use reddit as image hosting and it might take quite some time before anyone notices. This is a little worse though because it wouldn't even be listed on a profile page.

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago) (3 children)

Not familiar with Lemmy specifically, but usually in an app like this, while of course the files are stored on a filesystem, IDs and metadata are stored in the DB and associated with each other through relations. It seems in this case one way to express it would be 'don't delete every image that is associated with a valid post or in-use avatar, but delete everything else'.

Take this random image for instance: https://lemmy.world/pictrs/image/ede63269-7b8a-42a4-a1fa-145beea682cb.jpeg
associated with this post: https://lemmy.world/post/4130981

Highly likely the way it works is there is an entry for post 4130981 that says it uses ede63269-7b8a-42a4-a1fa-145beea682cb, or an image table with a relation to the post table where an image entry (with whatever ID) that is ede63269-7b8a-42a4-a1fa-145beea682cb says it is related to post 4130981. Whatever the specifics, it would be possible.

[–] [email protected] 2 points 1 year ago (1 children)

I haven't worked with Lemmy, but I certainly could craft a script to do that if I was familiar with the database structure. Perhaps I'll try installing it and running an instance. In the meantime, surely there's someone with an instance and SQL skills who could figure that out.

[–] [email protected] 2 points 1 year ago (10 children)

It would not be difficult to use SQL to delete any images that are not associated with a post or active as an avatar etc. So, set that to be run periodically and it would solve this problem.

[–] [email protected] 49 points 1 year ago

it's the usual 4chan racist bullshit.

[–] [email protected] 1 points 1 year ago

Yep! People think of it as an urban thing (i think?) but small city police use it as a way to abuse the fuck out of people.

[–] [email protected] 8 points 1 year ago

Like if you vomit and there's blood, there's a big difference between dark, dried blood, and fresh red blood. But anyway, this can vary vastly in severity, from simply rectal tears near the surface, to Chrohn's disease or tumors. You may wish to read this page (scroll to lower GI in particular) and it would be good to ask a medical professional and not just Lemmy.

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago)

Definitely varies by region or specific cities. And thanks! Yeah, the police and school administration where I lived were insanely punitive and pretty much out to get counter-culture type kids. I had a bunch of conflict with a middle school vice principal and a few years after I left he was fired for punching a student... so... they moved him to Principal of an elementary school. Our HS security guard was an ex DEA agent and he and the admin were obsessed with the idea of busting kids for smoking weed. Local cops were obsessed with the idea of pulling us over and searching us and the car, and we were 15-18. We didn't realize we could say no. One time we bought a bong at a local head shop and it turned out the cops were staking it out and followed us, then claimed the driver made a 'rolling stop' 100 feet before we got to the next city limits. We'd also get stopped just driving around not doing anything, if they saw 2-3 teenagers in a car. So, both the school and local police were pretty tough to deal with. In a midwestern town we moved to, my brother and a friend had this one cop who had it out for them who would walk up and just start jamming his hands in their pockets "am I going to find anything? am I going to stab myself on a needle?" (which makes no sense, they never did/got busted for IV drugs). I went into my 20s thinking I'd always have to be concerned about being pulled over and searched but when I moved to the SW it didn't happen again.

[–] [email protected] 1 points 1 year ago

Why would it be? I can get tofu and beans cheaper than even the subsidized rates of meat and cheese. If you buy processed vegan products, perhaps.

[–] [email protected] 1 points 1 year ago

It’s weird to me how much people focus on surviving widespread near-apocalyptic disasters. Why would I want to?

[–] [email protected] 2 points 1 year ago

Companies operating on that scale sell millions and millions of beverages. Even half a cent per can can add up to huge amounts of money. Also, their job is literally to sell containers of diluted high fructose corn syrup, so I don't think customer health is their priority.

view more: ‹ prev next ›