The last time I wrote about Lightroom, I was using sqlite to pull out frequencies of focal length. This time it’s keywords
This is pretty slick all by itself,... To do that, I use sqlite3 from the command line to dump the metadata table to a file, and then a short bit of R code finds the focal lengths and builds the histogram.
(tags: lightroom data analysis)
"to update the lightroom database when copying photos (and the lightroom database) from a mac to a pc"