CYPEX may be used to store highly critical data. In those cases, it’s necessary to track changes made to an entity. However, it’s not only about critical data - sometimes you simply want to debug an application and check what’s going on.

Enabling history tracking is easy: Go to the database setup page, and select the entity you want to track. Use the “Auditing” button to control this behavior.

Once this is done, the table is tracked by CYPEX. In the background, a couple of changelog triggers are deployed, which store all changes made to the desired objects in JSON format.

If you want to inspect these changes - and if you are a superuser - you can go to the admin panel and take a look at the data in detail:

It’s the task of the administrator or the person in charge of the application to handle the cleanup. We strongly believe that audit data should not be deleted automatically. For that reason, it’s necessary for end users to explicitly control what’s deleted, when it’s deleted and how it’s deleted.