You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There are multiple approaches to be do audit. This card aims to find the suitable approach for our product with respect to the requirements we have, easy maintenance and tech versions.
AC:
Have the below requirements/considerations when finding the approach.
We would be in need to programmatically access the revisions as well to be able to show them in the UI in DEA and app designer. (so not just checking in DB)
We also want to audit hard deletes.
In the version info, we need date time modified as well as who modified it, and the old data
Identify what will be the pros and downsides of doing for all tables vs selective tables
How does any related component - like sync, ETL, reporting will impact?
Is it possible to do without updating our current code to get the latest revision of entry?
Hibernate Envers seems to be a good approach. Validate the same by comparing the pros and cons with other available approaches technically. You can also add a POC if you think that might help for future stories.
Are all available features of the recommended approach available in the sping boot and java version we are using or will we face more tech debt by adding this when upgrading.
Need:
AC:
Have the below requirements/considerations when finding the approach.
Hibernate Envers
seems to be a good approach. Validate the same by comparing the pros and cons with other available approaches technically. You can also add a POC if you think that might help for future stories.References:
https://www.baeldung.com/database-auditing-jpa
Spring Boot Auditing using Spring Data Envers - https://www.youtube.com/watch?v=W1Rtn28lHU8
Auditing with Spring Data JPA - https://www.youtube.com/watch?v=Pc7Une_5rMs
The text was updated successfully, but these errors were encountered: