• xmunk@sh.itjust.works
      link
      fedilink
      arrow-up
      19
      ·
      2 months ago

      JSON in the DB isn’t an antipattern. It is frequently used in absolutely terrible designs but it is not itself a bad thing.

      I’m a data architect and I approve this message.

      • lengau@midwest.social
        link
        fedilink
        arrow-up
        9
        arrow-down
        1
        ·
        2 months ago

        Carrying the body of a smaller plane in a larger plane isn’t an antipattern either. Airbus does this between body assembly and attaching the wings.

          • Enoril@jlai.lu
            link
            fedilink
            arrow-up
            9
            ·
            2 months ago

            It’s “fuselage”.

            It’s called like that because of it came from the word “forme fuselé” (Tapered shape) and it’s a french word mainly because we created it in 1908.

            You’re welcome :-)

      • meliaesc@lemmy.world
        link
        fedilink
        arrow-up
        2
        arrow-down
        3
        ·
        2 months ago

        Why not use nosql if your important data is stored in JSON? You can still do all your fancy little joins and whatnot.

          • xmunk@sh.itjust.works
            link
            fedilink
            arrow-up
            3
            ·
            2 months ago

            Specifically so you get mature transactional guarantees, indices and constraints that let app developers trust your db.