• @ebu
    link
    English
    915 days ago

    I’m just talking about stuff more like Discord or Steam that are huge distributed systems that don’t use databases.

    huh???

    • @Hexarei@programming.dev
      link
      fedilink
      English
      815 days ago

      Whoops, I flubbed that message hard and didn’t catch it at the time: Meant to say “don’t use centralized databases.” They definitely use databases lmao. No idea how I screwed that message up so hard. I blame ADHD for not proofreading.

      Just so we’re on the same page, let me be more specific. I’m saying the individuals in the article were making terrible decisions. Lots of them.

      I am also saying that UUIDs are good primary keys for very specific purposes: Large, distributed systems that handle large amounts of small data, powered by databases like Cassandra that are designed to handle millions of record insertions per hour across several hundred nodes, to the point where inserts are very likely to happen at the exact same time on two different replicas of the same schema.

      Hope that makes more sense than my previous flub. lol

      • @ebu
        link
        English
        5
        edit-2
        14 days ago

        okay that’s a little more sensible lol

        i think the original comment that this thread is in reply to is avoiding non-monotonic UUIDs. i don’t think anyone is contesting that autoincrementing ints create headaches when trying to distribute the database

    • @froztbyte
      link
      English
      515 days ago

      See, reason being is they use aethernet - that’s the only way you get to get scale it like this. Without that, communication and storage would just be impossible!

      • @Hexarei@programming.dev
        link
        fedilink
        English
        815 days ago

        I accidentally a word in the original comment, it was supposed to say they don’t use *centralized databases. Instead it said I’m a moron lmao.

        • @froztbyte
          link
          English
          515 days ago

          Bit of a whoopsie, that :)

      • @froztbyte
        link
        English
        615 days ago

        And I just saw what that poster’s domain is, fuck me