mbari-org / annosaurus

Service for storing and retrieving video/image annotations from VARS
https://docs.mbari.org/annosaurus/
Apache License 2.0
1 stars 1 forks source link

Add history tracking with hibernate evnvers #28

Closed hohonuuli closed 8 months ago

hohonuuli commented 8 months ago

I've added history tracking to only the observation and association tables. Adding to imagedMoments presents two issues:

  1. The way the nightly merge happens can result in many, many thousands of updates every night. This would flood that audit table.
  2. UUIDs are not well handled by hibernate envers. Dealing with video_reference_uuid is a problem.