[Feature] store sidecar checksum

Source: immich-app/immich#7787 · opened by @mmomjian

The feature

We already store the file checksum as assets.checksum in PG. Inspired by #7786, we should also store the sidecar checksum as, for example, assets.sidecarChecksum. Even if this is not currently used, having checksums for all the external files that Immich depends on can greatly help with data loss and restoration in the case that the database and underlying library become out of sync. For example, with an untracked sidecar, we could now figure out which image it belongs to in case the filename is ambiguous. I'm not sure how sidecar updates are currently handled, but this would also allow us to determine when the contents of a sidecar changed.

The sidecarChecksum should probably *not* have a unique constraint, as these can be potentially duplicated between images.

Platform

• Server
• Web
• Mobile

3 years ago