TOPIC: Database History Question
#1890
Database History Question 6 Months, 2 Weeks ago
Peter asked:

Speaking of changes: i have issue with destructing of data in database depending on law (how long data allow to be kept). If i delete object from db it still keep history of change. I can remove history but then all history is gone. Can i remove history of only 1 object?
Currently there is no way to delete only some of the history. The only way to remove the database history is to compact the database (suneido -compact). This removes all the history.

The database history is just a side-effect of the way the database works. It can be useful for debugging but it is not intended to be used in applications.
 
 
andrew
 
#1891
Re:Database History Question 6 Months, 2 Weeks ago
OK, i understand. For records management it is handy/required to use history info. i can add record version numbering and no longer use history(). Does Suneido not use history in their apps?
 
 
#1892
Re:Database History Question 6 Months, 2 Weeks ago
No, we only use the history for tracking down problems.

We automatically optimize our customer databases at least once a week so we only have current history.

In a few places we keep our own "history".
 
 
andrew