Put Version in every SimpleDB entries

This way we can always do stale-ness check easily.

But then do we need to keep around the old stuff? Do we need to do real versioning?

If we do then this also means we'll then have two more "columns".

Business key and version. (Business Key??!! Ugh! Can't get away from Enterprise-software mentality). Why the need for business key? Well, the ID won't help because we'll have different ID per entries even if they are the same "thing". But business key is the same for different versions of the same "thing".

Question is what to do with old entries? Should they be moved to another space. Would it even save anything? Probably will confuse me more than help me.

On RDMBS, I would have another table or two for archives. But here?

Update 3/22/08 12:13pm

This wont' work. Keeping old version in the same space will make it really complicated to perform query (I always need to make sure I pick up the max version, etc). So either I do not do this, or move the item into another space.

Either way I do not need business key anymore.