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...
I don’t agree it was a good point. It sounds like the blog author missed a requirement a few times, and after getting repeatedly burned in the requirements gathering stage he now overcompensates previous failing with I’ll advised usages of timestamps instead of booleans.
YAGNI is always true. Always. The author’s point, even when timestamps end up being required, are moot.
Also, if state changes are required them you don’t tack on a timestamp to a row. You instead track events, including switching stuff on and off.
I feel this blog post is bad advise fueled by trauma.