I've upgraded my Macbook Air since Lion without issue. There's no reason to expect trouble coming from the new security features as homebrew/macports as well as sane make scripts default to installing outside system directories anyway. In the worst case, you'll just have to reinstall the offending applications.
Of course you still do a backup before in case the universe blows up.