But it’s not, they’re not doing actual piracy there, they’re talking about it, and that’s very much not illegal

This is by no means a vital service, but Imgur. Not the image hosting part itself, although the multiple self-hosted alternatives available are mostly aimed at photographs and surprisingly very few if any to memes and reactions for chats, forums and social media. On the other hand, the particular use case of sharing memes and meme dumps is not being fulfilled by anything else at the moment. Go to Imgur even on it’s current sorry decayed state and at any time you’ll find multiple people sharing image galleries, usually of up to 50 memes at a time, sometimes more. Lemmy, Mastodon and Discord servers try to fill that gap but right now they can’t.

Tangential partial offtopic aside: Unless i’m misunderstanding, you’re setting this up behind your home router and allowing it on your various devices using a VPN. Am i right? Any details, or even better, guides, on how to replicate this setup? I guess the DNS records on Leng are to be able to call services inside your home LAN by name instead of IPs, which is a nice quality of life upgrade.

VERY understandable, requiring a GPU would limit it’s application and spread, i hope a good GPU-less solution is found eventually

I am saving this post for the future, informative! Thanks!

Last i saw, the physical media version of their recent shows came with a box and a code to get it online, not actual discs, so they’re effectively getting out of the business of letting you own your media

Nothing specific, but Postgres date management is really, really useful, i can do a query on a date, parts of a date, timestamps, compare dates and times, intervals, all sorts of powerful operations. SQLite seems to have none of that, the date seems like a courtesy item added later as an afterthought because somebody asked or something, it has absolutely none of that, and when i have to do things with it it’s painful, relying on doing operations on the Unix epoch of dates for most stuff because the dates themselves are not really usable. Was hoping somebody else had done something to improve on this but doesn’t look like it.

Oh nice!