On Saturday, 16 April 2016 19:18:13 CEST, [email protected] wrote:
Is there a simple way of getting stats/summary of focal
lens used in a collection/film roll?
Darktable caches these values in its SQL database, so you can access the
data from there. Do not blindly copy-paste stuff into sqlite's console,
though, it has a potential of nuking your DB.
Here's a random sample of what can be done. A quick intro:
$ sqlite3 ${XDG_CONFIG_DIR:-~/.config/}/darktable/library.db
sqlite> .mode columns
sqlite> .headers on
Let's find the filmstrip that you want to operate on. The "image id" is
shown in the "image information" in lighttable:
sqlite> select film_id from images where id = 13809;
film_id
----------
84
sqlite> select lens, count(*) as num from images where film_id = 84 group
by lens order by num desc;
lens num
----------------------- ----------
Canon EF 17-35mm f/2.8L 402
Canon EF 70-200mm f/4L 216
Canon EF 24-105mm f/4L 181
(0) 97
Canon EF 50mm f/1.8 MkI 75
This means that my Sigma 35 1.4 ART (misidentified as that ultrawide Canon
zoom by exiv2, apparently) was my most favorite lens during that particular
event.
Drawing nice histograms should be pretty easy with some Python glue.
Cheers,
Jan
--
Trojitá, a fast Qt IMAP e-mail client -- http://trojita.flaska.net/
____________________________________________________________________________
darktable user mailing list
to unsubscribe send a mail to [email protected]
