With point and shoot digital camera's I have owned in the past, both F-spot and Digikam have worked well. Now that I have purchased a new DSLR I am looking into other types of software for photo management (and it will be hard for me to change after using digikam all these years....if I even change at all).

With the above being said, I have found blueMarine. It is our "Link of the Week".

blueMarine is an open source application for the digital photo workflow, the blueMarine project will provide you an all-in-one tool for managing your photos, from the shoot up to the archiving and beyond. blueMarine is an expandable, open platform and includes specific support for different photographers communities, as well as the latest technologies.

blueMarine foundation is very similar to existing applications such as Adobe Lightroom or Apple Aperture: a photo browser, which can be explored in different ways (by folder, by calendar, by tags, by galleries). This is just a core upon which different modules can be plugged in. The aim of blueMarine is to fully support the photographic workflow, even before the photo shoot (for instance, trip planning supported by maps) and beyond print or archival. For instance, an ornithologist usually manages field notes about the bird observed and photographed: directly binding them to photos and maybe GPS positioning data is much better than keeping a separate Excel sheet.