From the river to the sea, Palestine will be free 🇵🇸

Admin of orcas.enjoying.yachts and web dev of nearly 2 decades.

  • 0 Posts
  • 270 Comments
Joined 3 years ago
cake
Cake day: July 7th, 2023

help-circle


  • Go back to old consoles like I’ve been doing. I’m in the process of modding a PS2, and I’ve got a 3DS that is on Pretendo Network and has a fuckload of games installed on an SD card.

    Edit: forgot to mention that I also recently threw my old BD burner into an external case. So now I can archive stuff to DVD like we did back in the day. I’ve been really leaning into reviving old tech.


  • I can’t remember exactly what I did but enabling autovacuum was one of the big ones. I’ll try to provide some info below:

    Walks through VACUUM and autovacuum - https://oneuptime.com/blog/post/2026-01-25-use-vacuum-analyze-postgresql/view

    How to see if autovacuum is already enabled (these are commands you’d run while in sql):

    SHOW autovacuum;

    View current settings:

    SELECT name, setting FROM pg_settings WHERE name LIKE '%autovacuum%';

    Monitor which tables need attention:

    SELECT schemaname, relname, n_dead_tup, n_live_tup 
    FROM pg_stat_user_tables 
    WHERE n_dead_tup > 1000 
    ORDER BY n_dead_tup DESC;
    

    I wish I had documented it at the time because info about this for Lemmy specifically is pretty lacking. I was in kind of a dire situation though because my disk space had filled up quickly and my system was struggling. A lot of what I did was basic PostgreSQL maintenance stuff, so you should be able to find some general guides for that.

    EDIT: I had Claude help me corral some optimization stuff into a PDF. This is along the lines of what I did to get my db back under control. Make sure to always backup first! https://u.orca.casa/1771250081






  • As someone that turned a programming hobby into a career… it fucking sucks. I don’t have enough time in the day to get back to hobbies, so when the work day ends, zoning out to video games late into the night becomes my main quest. Can’t complain but this full-time job side quest fucking sucks, especially with AI muscling into everything and sucking the oxygen out of the room.






  • Okay, let’s say he stole the election just for the sake of an exercise. There are a metric fuckton of regime change examples where the US meddled with the elections of other countries for their own gain. Is Venezuela now the magical example where the US government did it simply out of the goodness of their hearts? Or is this just a convenient scenario where Maduro needed to go and the US just happened to be the ones to do it and that’s somehow totally cool? I mean, fuck the approval of Congress, international law, etc. amirite?

    Venezuela’s issues and elections are for Venezuelans to decide, not parasitic imperialist scum. The mental gymnastics to support this one are on an Olympic level of stupid.



  • I think part of it is that those supposed leftists don’t categorize all of those capitalists the same way. It’s like they view billionaire CEOs and landlords as different groups, when the reality is that they fall into the same capitalist bucket. So landlords being stripped of their hoarded properties so that everyone can have a home, is not viewed by them in the same critical light as a CEO that hoards wealth and exploits the working class.

    I don’t have anything solid to back this up. It’s just my general observation. It all boils down to class consciousness and decoupling oneself from propaganda.