[digiKam-users] Lens and camera statistics for tens of thousand of images

[Remco Viëtor]

On mardi 19 avril 2022 02:24:06 CEST digikam at 911networks.com wrote:
> DK 7.6.0 appimage with an sqlite db
> 
> I think that later this year, I will upgrade my getting old camera to
> ... I'm not sure. So I was looking for some way of analyzing my
> images and finding both the focal lens and the aperture used for a
> specific date range, like the last 3 years.
> 
> I have found an old (2012) script that claims to do that but only if
> the DK db is mysql.
> 
> Any way in DK to get that info? or other ways?
> 
> Thanks
The "advanced search" would also allow you to select per lens, or focal range. 
In my case, it offers a pick list for both camera make/model and lens model.
Not as nice as a sorted list per focal range and aperture, of course...

Depending on how many images you're dealing with, exiv2, grep and a bit of 
creative scripting might do the job as well.
Or use a program to look into the sqlite database.

Of course, you can always convert your database to mysql.
But if the script is that old, it may very well not work, if there have been 
changes in the database scheme. 

I'm not sure about the usefulness of such an approach. It will tell you what 
combinations you used, but not what you would have *wanted* to use (or which 
shots you couldn't take with current equipment...). 

Remco