Clever ideas that failed
sites.google.com
sites.google.com
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.
http://sites.google.com/site/yacoset/
Many of his articles have been posted on HN and elsewhere already.
<Shipments>
<LineItem LineNumber="1" SKU="123456">
<Order Number="555444">
<Package ShipMethod="UPS" Tracking="1Z123467WW53631"/>
</Order>
</LineItem>
<LineItem LineNumber="2" SKU="654321">
<Order Number="555444">
<Package ShipMethod="UPS" Tracking="1Z123467WW53631"/>
</Order>
</LineItem>
</Shipments>
The designer of this schema was on crack.
http://sites.google.com/site/yacoset/Home/an-open-letter-to-...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)....
It is true, however, that adding in that time dimension makes everything a much, much harder problem.
Loved it. Looking back, I have sinned as well.