Jesus died at 33, so that can’t get returned in the query response lol

  • Whelks_chance@lemmy.world
    link
    fedilink
    arrow-up
    16
    ·
    1 year ago

    Realistically you wouldn’t store age, you’d store birthdate or possibly a datetime value, and calculate it from there

    • hansl@lemmy.world
      link
      fedilink
      arrow-up
      6
      ·
      1 year ago

      First Normal Form users unite!

      By the by, as someone who have used both NoSQL and SQL extensively (once in the same project), the trick of NoSQL is that you shouldn’t use FNF and compute that at write time. The idea is that it’s faster to MapReduce pre calculated values since that’s the operation you want to optimize in a NoSQL world. A lot of people get that wrong and just replace MySQL with Mongo without rethinking usage and schemas.

      But even in a NoSQL context I’d rather use a Postgres jsonb column over MongoDB.