I usually drink in The Scottie or Broadfields. Been in plenty worse boozers than those two.
Scotties is a quiet pub. Occasionally get some nonsense going on in Broadfields, but it's usually just handbags.
Eta: Giovanni's is the chippy, which is one of the best in Edinburgh.