For a number of years I've used F-Spot as my photo manager. I have strong mixed feelings about the software, but it's generally served as a crucial part of my personal content management. Unfortunately, after an F-Spot bug ruined my photos' date/times for the second time, I haven't organized any of my photos since 2008!
With a digital camera chock full of photos from my roadtrip through five states, an engagement party in Mexico, and two separate weddings (not to mention the daunting, dusty collection of college graduation photos) I checked to see if F-Spot had had any recent updates...and discovered that F-Spot is no longer under development.
Previously I had considered trying Shotwell but was turned off by some missing features I felt I needed. The latest version now appears to all of those features, and even a wish I had had for years: it supports videos, too! If all goes well, expect to see some new photos on Flickr soon!