The title pretty much says it all - I’m interested in people’s recommendations (including recommendations against any particular software).
Some information, in case it helps:
We use a mix of PCs and Macs at our office but the graphic/communications work is all done on Macs, so that’s where our photo database will be stored.
We have hundreds if not thousands of photos sitting on a hard drive, minimally sorted by folders, that we would like to organize, first at a macro level and then with the possibility of fine-tuning. Ideally, the software will allow us to do a “mass tagging” of a lot of related photos at once, and also allow us to go back later when we have time and add more individual tags to particular photos, so we can find them when we need them for our publications. (I’m sure this is all standard fare for photo databases.)
We’d also like to be able to upload photos easily - of course to flickr and Facebook, but if there is software that will let us set things up so we can easily upload to our own website, that’s even better. (That is probably too much to ask, though, isn’t it?)
I though iPhoto would work beautifully for all of the above, but it seems as if dumping in a lot of photos from a hard drive and going back later to add tags is actually a rather clunky and miserable process - or so I’m told by colleagues, I haven’t tried it myself.
Recommendations and descriptions of your own experiences with photo database management in an office setting are welcome. Thanks in advance for all insights posted.
(Mods, if this is better suited to GQ, feel free to move - I figure that since I’m looking for software recommendations, it is more of an IMHO thread. But it doesn’t really matter.)