Here is a nice utility I found on gentoo forums. elogviewer is a nice portage log viewer written in pygtk. You need at least portage 2.1. Since version 2.1 portage has a new logging mechanism called elog. You can get elogviewer from here. Many thanks to synss and nmbrthry.
F-Spot 0.1.11 ebuild just hit portage. It uses sqlite3 now instead of version 2. I found this post interesting on how to upgrade f-spot database to version 3. Basically you need to do the following (copy & paste from the post).
cd .gnome2/f-spot
sqlite photos.db .dump|sqlite3 out.db
mv photos.db photos.db.backup
mv out.db photos.db
Now you can unmerge sqlite2. Happy f-spotting 
.
