I work at an organization that makes extensive use of photography and we need an better way to organize all our photos. We have several staff and volunteers who take photos regularly. Then we use these photos in a variety of different media throughout the year.
We currently have about 50k photos stored on a shared file server, but it's very difficult to organize. I'd like to have a database to keep track of the photos so that each photo can have fields that we populate with our own data. For example, I'd like to be able to easy query the system for requests such as "all photos within a date range", "all photos shot by a particular photographer", "all photos taken at a specific type of event, across multiple years", "all the top rated photos within a date range", "all photos featuring a specific person" etc.
For personal photography, I've tried digiKam and F-Spot, which are great, except that they're only designed for one user. We need a more collaborative solution that will allow multiple users to interact with the system simultaneously. Ideally it would be web-based. Free and open source would be another plus.