Lightroom catalog and referential integrity not being enforced. Why?

  • 2
  • Question
  • Updated 4 years ago
I have been interested in how Lightroom uses the catalog so was poking around a backup of the catalog. I am a database administrator and I found it rather concerning that although the database (catalog) is pretty well designed, there is no referential integrity defined or enforced. This is non-standard practice and could well be the source of corrupt catalogs I have seen many people complain about. I would strongly recommend the developers modify the catalog and adopt best practices if they want to improve the stability of Lightroom and the catalog.
Photo of Keith Ross-Jones

Keith Ross-Jones

  • 9 Posts
  • 0 Reply Likes
  • Concerned

Posted 4 years ago

  • 2

Be the first to post a reply!