• learningduck@programming.dev
    link
    fedilink
    English
    arrow-up
    2
    ·
    1 year ago

    How do you update it to unoublish? Add another timestamp column and who’s the latest win or just set published_at to null?

    • pie@programming.dev
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 year ago

      You wouldn’t store this information on the same table (unless you’re using a wide row db like dynamo/Cassandra). In a SQL world, you’d store version information in a separate table - one table for the HEAD state and another for history.

      • learningduck@programming.dev
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        So, the history table have every column, but the user table has only user id and version, right?

        user_history table user table