I don't know if I'm missing something big, but getting Perl, Apache, PHP, PDO and MySQL to play nice on my Mac OS X 10.5 install on my Intel Core 2 Duo (Penryn) MacBook Pro hasn't been easy. This is partly thanks to Apache being compiled with x86_64 support, and Perl with i386 only.
I finally got sick enough of GoDaddy to buy a Dreamhost account and transfer (nearly) everything over to that account. Although I've only been using it for a few hours, I know I'm going to be far happier with it... especially the Subversion support. Setting up a post-commit hook as described below has made maintenance a lot easier.
EXIF/IPTC/XMP tagging of GPS coordinates, folksonomy tags, and other goodness is a nice idea, but unfortunately, iPhoto and Flickr don't play too well together. Couple this with the fact that any decent support those products now have is not included for photos already imported into them. So, here are some notes resulting from some experimentation, along with the Perl code I wrote along the way.