[Fritsdehacker]

I like digikam. It mirrors the internal photo albums with directories on the disk, so if you want tot browse tour photo's directly, you can still find them easily. Things like labels, comments and ratings are all stored in a little database file. You can view by album, but also by date or use custom filters.