#DailyBloggingChallenge (144/200)
One downside of using #Shotwell as a photo and video manager is that it isn’t that straight forward to extract tags from videos as it is with photos. With photos one can grab the data directly with an #exif tool.
After going through the source code and battling with #sqlite and #bash, I got a script that extracts tags from both media formats.
The nice thing is that it is more performant than the previous script I was using only for images.
#DailyBloggingChallenge (145/200)
The
TagTable
has aphoto_ids_list
which contain each photo or video with the specific tag. Further eachid
is either prepended bythumb
for photo andvideo-
for video. Theid
itself is saved as a hexadecimal number.Once one has the
id
’s as a decimal number, one can use it to search through either thePhotoTable
orVideoTable
.