Is there a way (Using a Lua script in darktable perhaps?) to get access to the list of "currently selected images?" That way we aren't re-inventing the process of picking images in the database, instead the user could select the collection they want using darktable's existing graphical interface and then pass the list of images to an analysis script. That would allow collecting images easily by film roll, date range, subject tag, combinations of criteria, etc.
Regards, Owen On Sun, Apr 17, 2016 at 1:44 PM, Jan Kundrát <[email protected]> wrote: > 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] > > ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
