sorted by: new top controversial old
What’s your favorite video game that most people didn’t like ?? in c/games@lemmy.world
[–] 11 points 1 month 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

  • permalink
  • fedilink
  • source
    •
    F24 Lithuanian living in Scotland. Ask me anything Dirty or Clean in c/asklemmy@lemmy.ml
    I can now save my game in Pokemon Yellow again after 25 years. in c/games@lemmy.world
    How much of the enchilada do you want? in c/shittyasklemmy@lemmy.ml
    I Decompiled the White House's New App in c/programming@programming.dev
    Recommend games for me in c/pcgaming@lemmy.ca
    [–] 20 points 5 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.

  • permalink
  • fedilink
  • source
    •
    UneXpect — In a Flesh Aquarium [2006, avantgarde/progressive/operatic metal / mathcore]: kinda eclectic in c/metal@lemmy.world
    The Problem with A.I. Slop! - Computerphile [14:57] in c/videos@lemmy.world
    [–] 3 points 8 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

  • permalink
  • fedilink
  • source
    •
    NPM Supply Chain Attack: Is the Coast Clear? in c/sysadmin@lemmy.world
    [–] 4 points 9 months 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.

  • permalink
  • fedilink
  • source
    •
    Poppy, Amy Lee, Courtney LaPlante - End of You (Official Music Video) in c/metal@lemmy.world
    Weekly Recommendations Thread: What are you playing this week? in c/patientgamers@sh.itjust.works
    [Epic via Prime] *Marvel's Midnight Suns*, card-based tactical RPG in c/freegames@feddit.uk
    9
    Are these queries equivalent? (lemmy.ca)
    submitted 11 months ago* (last edited 11 months ago) by to c/sql@programming.dev
    14 comments fedilink
     

    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)"

    22
    Which Lemmy web frontend is most popular? (lemmy.ca)
     

    I was just taking a peek at the various frontends supported by lemmy.ca, and I was wondering if the admins here have any insight into their respective use?

    I'm going to bet the default (lemmy-ui) is most popular, but do any of the other frontends get far-and-away more use than the other alternatives? Has there been any trends up or down? Just thought I'd ask.

    As an aside, if any of the frontend developers happen across this post, well done to all of you! I can immediately see the appeal of each, so each niche is being filled darn well!

    Edit: to be clear, I'm talking about the frontends listed on the lemmy.ca main sidebar.

    view more: next ›