Fremantle
I seem to be giving up (for now) on the idea of a database of photos that I've taken. A while ago it occurred to me that it's silly to keep all photos together just by virtue of the fact that I was the one to click them. Far more useful to sort and store them by usage and proximity to other data.
So I'm experimenting with a document-centric approach, where a wiki page serves as what in other systems might be a tag or album or category. Photos (and other files) can be embedded into that page, and gain their metadata from the page and their place within it. It's looser approach, more like a scrapbook or commonplace book, and I will probably also add at least some per-file metadata (e.g. time and coordinates) at some point. Most of what I want in a record-per-photo system I seem to now be getting from a combination of a calendar view and some manually created lines on a map.