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...
  • 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