The simpler media website CMS
Not long ago, I added some mp3s to a USB of my favorite music. I stored it, like always, <artist>/<album>/<tracks>, and I was surprised to learn that when I played that USB in the truck, the tracks were not organized like that at all! I learned that each track has a set of tags, id3v2 in this case of mp3, which the mp3 player reads and creates the implied groupings. Eye-opening! So, I spent a few days fixing my tracks. Why is this important? Because the meta-data for each track is included with the track and is preserved if I move it.
So, this raised the question about my pictures and videos. If I spend time and effort tagging pictures, I would like to know that my effort is persistent and loss of a database will not take all my hard work with it. Are Zenphoto tags being stored as "exif" tags in the image file and id3v2 tags in the audio/video file or are they being associated with the file and stored in the MySQL database?
Thanks for the help,