Open Stack

If the deleted column is removed, how would the 'undelete' functionality be provided ? This saves operators when user accidents occur since restoring the whole database to a point in time affects the other tenants also.

Tim

> Hi all,
> 
> >>> I've never understood why we treat the DB as a LOG (keeping deleted == 0 records around) when we should just use a LOG (or
> similar system) to begin with instead.
> 
> I can't agree more with you! Storing deleted records in tables is hardly usable, bad for performance (as it makes tables and indexes
> larger) and it probably covers a very limited set of use cases (if
> any) of OpenStack users.
> 

If the deleted column is removed, how would the 'undelete' functionality be provided ? This saves operators when user accidents occur since restoring the whole database to a point in time affects the other tenants also.