• 2 Posts
  • 12 Comments
Joined 1 year ago
cake
Cake day: June 10th, 2023

help-circle

  • 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.




  • 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.








  • You’re expecting something like the Digg to Reddit mass emigration. That likely will never happen again, the conditions for that are gone. What’s happening is what i predicted for years, people are moving away from the site but not going to a single “replacement” place as there’s just nothing like it, but to many. Be it the Fediverse, Discord, Facebook and related properties, various chats, even forums and freaking IRC.

    And it’s also clear it’s not going to be a single massive exodus, but a slow decay over a long time. The site will still be alive ten years from now, like Livejournal and other relics of the past are still technically alive, but will slowly fade from relevance.

    And one important thing: Sites like that depend on a few users, the so-called 90-9-1 rule explains it well, only a tiny, tiny percentage of users of the site produce the content it needs to survive, and they’re precisely the ones the administration pissed off. And not only that, but it depends on the moderators, without them the site would devolve to a sewer in no time, and they too have been shafted by the administration. A good portion of them have left the site for good, and the hit will be perceived in time, as they cannot be replaced easily.

    Everything that made the site good is dying or dead, let it die, or just survive as a zombie. It will become a cesspool of reposts, recycled content and garbage, and any user that creates good content that still remains there will eventually leave at seeing what the site will turn into.