Login






Lost Password?
No account yet? Register
Home arrow Forum
Suneido User Forums
Welcome, Guest
Please Login or Register.    Lost Password?
Database History Question (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: Database History Question
#1890
andrew (Admin)
Admin
Posts: 693
User Offline Click here to see the profile of this user
Database History Question 7 Months 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.
 
Logged Logged  
 
andrew
  The administrator has disabled public write access.
#1891
Peter (User)
Posts: 76
User Offline Click here to see the profile of this user
Re:Database History Question 7 Months 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?
 
Logged Logged  
  The administrator has disabled public write access.
#1892
andrew (Admin)
Admin
Posts: 693
User Offline Click here to see the profile of this user
Re:Database History Question 7 Months 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".
 
Logged Logged  
 
andrew
  The administrator has disabled public write access.
Go to top