In my 15+ years of web development, there are very few things I can say are unequivocally a good idea. It almost always does depend. Storing timestamps instead of booleans, however, is one of those things I can go out on a limb and say it doesn’t really depend all that much. You might as well timestamp it. There are pl...
  • learningduck@programming.devEnglish
    3·
    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.devEnglish
      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.devEnglish
        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