All,
I am looking for an application or perhaps just a framework that will allow me to store my photo files in a single place but all them to be presented as if they existed in multiple places. This seems like a good job for a database but representing a hierarchical structure with arbitrary depth seems less than obvious.

Let me give an example. Suppose I have a photo of our wedding that includes a half a dozen people. I may want to tag that photo under the main category of "Events" with a sub category of "Our Wedding". Additionally, I may want to tag the file under the main category of "People" and then under the sub categories for each person in the photo.

The goals of the application would be:

• Allow the number of pictures being viewed at any one time to be limited to the scope of the currently selected category
• Make the management of "tagging" files and creating the hierarchical structure user-friendly
• Make use of the other "tags" for a file.

I realize the last goal isn't very well defined. Basically, I would want to know when I am viewing photos from our wedding who is in the picture by being able to view the other tags.

Does anyone know of such an application - preferrably OpenSource and in particular Perl?

Disclaimer: No, I haven't done my research. Yes, there may be a number of non-perl solutions. I don't know the first thing about the topic at hand to begin making any informed decisions and that is why I am asking here.