Is there a database program that plays nicely with Lightroom?
I currently use Lightroom for organizing photos into location and species, and a spreadsheet for keeping track of other information. But, at over 100,000 photos, Lightroom is struggling - it freezes up several times in the course of a session.
I want to start generating flights data for moths, i.e. tracking all occurrence dates, and neither of them work well for that.
What I would love is something that could extract dates and species ID # from Lightroom metadata. What I will probably have to settle for is manually (arrgghhh!!) entering all that data for species of interest.
Any ideas? What programs are y’all using for data management?