Re:Rich Hickey: Deconstructing the Database
by bmurphy1976 on Tuesday August 28, 2012 @09:50PM
(#4446718)
You wouldn't. You can't change history either. You would insert a compensating transaction and the data would be fixed from that time forward when you inserted the compensating transaction.
[ Parent
| on HN ]
Re:Rich Hickey: Deconstructing the Database
by sbmassey on Tuesday August 28, 2012 @11:25PM
(#4446930)
Figures. So I guess that, in the case where you both need to worry about fixing invalid data, and also need to do historical queries, you would have to add your own timestamp to the data to represent the actual time of the event, because the built-in timestamp is just giving you the time of the state of the database. Hopefully that wouldn't get too hairy.