#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.
