Follow
#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 a `photo_ids_list` which contain each photo or video with the specific tag. Further each `id` is either prepended by `thumb` for photo and `video-` for video. The `id` 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 the `PhotoTable` or `VideoTable`.