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...
This is a nope. Often you need both. Like ‘active’ and ‘active_modified_timestamp’. Ir even better, build it like an enterprise developer should and build an audit table to track these kinds of updates and be sure to add who or what updated it in addition to when and what changed.