My suggestion on setting up Magento's app/etc/local.xml file for dev/stage/prod environments
It seems as though everyone always wonders what to do with app/etc/local.xml, and how to best manage it when deploying from development to staging and production. It took me a while to figure this out, but I think I found a really good way.