• 1 Post
  • 710 Comments
Joined 3 years ago
cake
Cake day: June 15th, 2023

help-circle




  • /u/spez is the effective reason.

    Reddit was great for me, back in 2008, but over the years slowly got more and more “normy”/less technical, more drama, more celebrities, the new UI, letting in the Digg refugees, not keeping old.reddit.com somewhat up-to-date while forcing me to use the new UI for certain pages, letting users get banned from subreddit A because they ever posted on subreddit B, with the API bullshittery as the straw that broke the camel’s back. Oh, and the MASSIVE amount of shadow-banning/deletion that happens. You have NO idea how many comments get removed, just from your own account. Check out https://www.reveddit.com/ for evidence.

    I slowly deleted 9 of my 10 accounts (one of them was combine_policeman, which I used to tell a user to “pick up that can, hehehehe”), kept my last one, until I made a flippant comment about whether Americans were going to burn down a city, because Mrs Good got killed (because, you know, people burned down their own city after George Floyd), which I said because I know white Americans don’t care about their own. Individualism for thee, but not for me, and all that.

    Anway, felt offended about the warning (and deleted comment), so I deleted my account that night. Fuck 'em.

    I already had done a request-for-data, which I used to delete my thousands upon thousands of comments from the site. Because fuck 'em!

    Lemmy/programming.dev feels so much more like 2008 Reddit, it’s insane. There are more communists here, than 2008 Reddit, but they had a bunch of Libertarians, so it evens out, lmao.















  • I’m a programmer and have switched to NixOS, because I can define all my configurations in code+git repo, which is great. I now have a single repo that has some parts that are shared, and some parts are host-specific (one desktop + 2 laptops, for now), and if I fix some bug (like my Samsung 990 Pro SSDs having Linux issues), I know it’ll be permanently fixed, instead of having to re-figure everything out after a reinstallation.

    NixOS BTW. We’re making it ours.

    edit: Steam has been a non-issue, so gaming has been great so far! Not that I’ve been gaming a ton, but still.

    Also, being able to use an LLM to fix stuff for me in my nixcfg repo has been great - I would NOT have been as productive with NixOS had I not have had Codex.


  • Here’s my quick guide to fixing slow queries:

    1. grab your query.
    2. run EXPLAIN ANALYZE <query>
    3. If there’s a Parallel Seq Scan, check the Filter value (which column are we checking) - you should likely try adding an index.
    4. run CREATE INDEX ON <table>(<column>);
    5. run EXPLAIN ANALYZE <query> again to check for improvements

    Note that EXPLAIN <query> will only do a rough analysis, while EXPLAIN ANALYZE <query> will run your actual query, and analyse it.

    If you want to ANALYSE EXPLAIN an INSERT query, do this:

    BEGIN;
    EXPLAIN ANALYZE INSERT ...;
    ROLLBACK;
    

    A simple ROLLBACK will help you here.

    Rewriting the query will typically not do much - it might, but the chance it relatively small vs slapping an index on it.