Wow. This is brilliant. Especially the sins committed, as I am also guilty of a number of them.<p>This has inspired me to begin looking back at my projects and compiling a similar list of things that I have learned by doing it wrong.
If you haven't already, check out this guy's growing treasure trove of writing:<p><a href="http://sites.google.com/site/yacoset/" rel="nofollow">http://sites.google.com/site/yacoset/</a><p>Many of his articles have been posted on HN and elsewhere already.
Hey what a coincidence! I dunno why he failed with the 4th one.<p>We maintain a leasing administration system here, and one of the most important/critical features is doing the thing he describes. You can know the exact state of any leasing contract (or a group, or all of them) by chosing a date of the future and past. That way you can compare the expected result vs reality. It is implemented fully inside a SQL DBMS (and works fine)....