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

help-circle






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





  • I keep feeling that there’s a disaster being brewed there, the only people paying attention to young boys seems to be the alt right, and there’s a need for this which everybody seems to dismiss, every single one of the old style support structures for masculinity have been dismantled over decades, and while they were right to be dismantled all these boys still need the support to actually grow into decent people, and no one is giving it, and these crazies have noticed and are using it as breeding ground for soldiers for their cause. The decent people side must create something for them even if it’s to avoid them falling into these dens of craziness.




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