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

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

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

help-circle

  • Here’s the take I read elsewhere:

    • Meta is pushing this hard through various lobbyist groups and shell groups
    • The supposed reasoning is that because of the massive flood of bots on the internet, advertisers are now incapable of discerning between bots and humans. This is bad for the advertising industry, so advertisers are apparently bailing on Meta. This means Meta is bleeding income on that front
    • To stop the bleeding, Meta is pushing age verification for a few reasons: 1. It signals that the entity on the other side is indeed a human and this gives advertisers more confidence; 2. It ensures that advertisers are not advertising to children (a big no-no)
    • Next up comes the government buy-in. They see this as a new wedge for pushing mass surveillance and shoving tons of people out of the shadow of privacy.

    Here’s a chart I grabbed from elsewhere that shows how Meta is achieving this and how the money is exchanging hands:





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