[–] 5 points 1 month ago (2 children)

My wife was just explaining that the body of her child is being held for evidence. Theoretically, the case would be closed after the execution and the body could be returned and buried.

I'm no expert on the case, but I could imagine the frustration of waiting for that for 30 years, only to have it yanked away minutes before.

All I'm saying is it might be bloodthirst, but it also may be just general frustration at the long, drawn-out process.

  • source
  • parent
  • context
  • [–] 7 points 1 month ago (1 child)

    My wife and I watched the whole first season together. I would return for a second season.

    It’s got a good balance of new (in its casting, location, and ‘worldbuilding’) and old (it’s a grounded character-driven sitcom - good execution, but classic plot line hooks).

  • source
  • [–] 20 points 3 months ago (8 children)

    Not a bad meme, but it feels like the Venn diagram of people who have been playing 50+ years, know about the Alt-F4 prank, and can’t figure out how to reload would be a pretty tiny overlap…

  • source
  • [–] 11 points 5 months ago (3 children)

    I wonder if it would still hold up to me, but I really liked True Crime: Streets of LA on the Gamecube. I'm led to believe it was not well received, and is derided as a bad GTA clone

  • source
  • [–] 18 points 9 months ago (2 children)

    Just in case you haven't played it, the first SUPERHOT is, IMO, quite a bit better than the second, so I'll toss that in there.

    As a wilder card, I'll suggest the Batman Arkham games. I think Arkham City is probably the most well-regarded of them.

  • source
  • [–] 3 points 11 months ago

    I recognize that it's a workaround for a problem foisted on us by idiots and we shouldn't have to deal with it, but I like the absurd notion of a "Spam folder" of websites

  • source
  • [–] 4 points 1 year ago

    Yes and no. The truth of the matter is supply-chain attacks in any repository are almost impossible to fully mitigate. The attack you linked sounds like a big and successful attack, but there are more minor attack attempts all the time. It’s the blessing and curse of every package manager that anyone can upload almost anything.

    The upshot is that the most active repos have the most eyes. Not to say an attack won’t fly under the radar, but if the React or Angular packages (or their dependencies) start acting weird, it’s more likely that someone will notice, as there are people dedicated to auditing such things.

    Furthermore, a lot of the smaller packages do “one thing” (see the infamous is-even package), so they are small and easy to self-audit if you are paranoid enough.

    It’s not perfect, and there will always be more headlines about the next big attack, but it’s still a boon overall IMO.

  • source
  •  

    Putting aside any opinions on performance, I've been trying to test a notion about whether a couple queries would output the same data (ordering doesn't matter).

    SELECT *
    FROM articles
    WHERE (
      last_updated >= %s
      OR id IN (1, 2, 3)
      )
      AND created_at IS NOT NULL
    
    SELECT *
    FROM articles
    WHERE last_updated >= %s
      AND created_at IS NOT NULL
    UNION
    SELECT *
    FROM articles
    WHERE id IN (1, 2, 3)
      AND created_at IS NOT NULL
    

    I think they're equivalent, but I can't prove it to myself.

    Edit: Aye, looking at the replies, I'm becoming aware that I left out a couple key assumptions I've made. Assuming:

    a) id is a PRIMARY KEY (or otherwise UNIQUE)

    b) I mean equivalent insofar as "the rows returned will contain equivalent data same (though maybe ordered differently)"

    view more: next ›