I've written something that's about 60% of what you're looking for, and it's in Perl, and while I hadn't considered licensing issues, I think I'd tend towards the PAL. I've kind of stalled with moving forward with refactoring and other changes, because it pretty much does everything I want (so far!).

Here's why it could likely be adapted to what you're looking for:

• All the files are in a big directory, with thumbnails in another directory, with filenames based on timestamps.
• All pictures (for which I've logged in and added an entry ;) have an entry in a mysql database.

I could easily see modifying my database schema to allow for 'tags', and the indexing CGI to query the database for a given set of tags.

Here's a link to it in action, and the code for the indexing CGI is included here in a <readmore> should you be interested. (There's also some of the modules used listed here which I won't place here for (some!) brevity)

I could actually be persuaded to add this for myself, as I find that I have 'sets' of pictures of my own that it might be nice to 'sort' by - house pictures, construction pictures, party pictures, dog pictures, etc. :)

$,=42;for(34,0,-3,9,-11,11,-17,7,-5){$*.=pack'c'=>$,+=$_}for(reverse s
+plit//=>$*
){$%++?$ %%2?push@C,$_,$":push@c,$_,$":(push@C,$_,$")&&push@c,$"}$C[$#
+C]=$/;($#C
>$#c)?($ c=\@C)&&($ C=\@c):($ c=\@c)&&($C=\@C);$%=$|;for(@$c){print$_^
+$$C[$%++]}
[download]

I havn't used it, but there is CGI::Application::PhotoGallery. I would also check the C::A archives and wiki to see if there is anything else out there.

--MidLifeXis

I haven't tried it myself, largely because (like far too many other people) I've been working on-and-off on a similar project of my own, but it looks like FotoBilder might be exactly what you need. Fairly strictly web-based, and requires mod_perl (unless I'm very much mistaken), but if you don't mind those constraints, it seems like it could work pretty well for you.

I've been playing with something similar (havent' we all?). My solution is based on Win32 but I think the same idea will work for *nix. What I wanted was to have a system that in the end, regular applications could access the pictures through there tags. This meant either hacking into the windows file system (which seemed scary and dangerous) or abusing the current system. So I set out to abuse the current system! ;) It turns out that you can do Hard links in windows if you download the right tools. So i have a script monitor a directory, and when a picture is added, it takes all the directories and uses those as tags. For instance if i put a picture in 2005/March/Eric/Mountains it would be tagged with all four of those. Then hard links are distributed out into the other approriate directories. In this case a hard linke would be put in 2005, March, Eric, Mountains, 2005/March, 2005/Eric, 2005/Mountings, March/2005, March/Eric, etc. I'm still working on getting the monitoring right, but right now it looks very promising and exciting. I get the heirarchial access method of starting with broad tags and then as you enter directories you get pictures more and more related to what you want. In the end I want to then tack a web based interface to allow easier tagging and searching of pictures.

I know this isn't quite what you want sense i don't have sub-tags likey are thinking, but maybe there is some way to weld the two ideas together ;). Of the top of my head sub categories could be folders prefixed with something like "." so that the two systems could be merged. Then when storing the categories in a DB you concat the main category with the sub category and store them that way. /me stops thinking out loud.