• @Hexarei@programming.dev
    link
    fedilink
    English
    -1
    edit-2
    4 months ago

    They’re good for large, distributed applications for sure. Better than incrementing integers for those kinds of applications at the very least.

    For the folks in the article though? lol they were making no good decisions

    • deborah
      link
      English
      14
      edit-2
      4 months ago

      when you do not yet have (1) customers, (B) unit tests, (ג) developers who can write their own code, or (IV) exception handling, the term-of-art that comes to mind for doing anything besides auto-incrementing primary keys is YAGNI. (Especially because nobody who is making thoughtful, careful database tuning decisions is using chat-gippity to convert their models. And more to the point, they aren’t using SQLAlchemy of all things to make large, distributed applications that need UUID primary keys.)

      • @Hexarei@programming.dev
        link
        fedilink
        English
        0
        edit-2
        4 months ago

        Oh for sure, the article folks are inept and absolutely not the people I was talking about. I’m just talking about stuff more like Discord or Steam that are huge distributed systems that don’t use centralized databases.

        Edit: that don’t use centralized databases. I blame the ADHD.

        Edit 2: I am agreeing with this person

        • @ebu
          link
          English
          94 months 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
            84 months 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
              4 months 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
            54 months 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
              84 months 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
                54 months ago

                Bit of a whoopsie, that :)

            • @froztbyte
              link
              English
              64 months ago

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