I am looking around for a photo management solution. I understand that some photo managers store tags in the photo themselves whilst some use an application specific database. I also understand that some managers overwrite the original image when editing and some do not.
However I have not been able to find a comparison sheet concisely summarizing the tagging and editing methods used by different programs. Therefore I would be very grateful if people could comment on photo management software they are familiar with, specifically in terms of how a) tags (in database or in photo) and b) edits (destructive or non-destructive) are implemented.
e.g. Program A, tags in metadata, edits destructive; Program B, tags in database, edits non-destructive, etc
Please also mention any noteworthy non-standard quirks in implementation (e.g. I have heard that Windows photo gallery does geotagging in a non-standard way).
Feel free to comment on any photo management software you are familiar with. However, I am particlarly interested in the following: iPhoto, Windows Photo Gallery, Picasa, Photoshop Elements, Photoshop Lightroom, ACDSee, Corel Aftershot Pro