Digikam is an open source, multi-platform photo organizer.

It could be a useful alternative to Lightroom or ACDsee, if used in conjunction with a photo editor.