Generally the people are warm and friendly, the stabbie thing is really in the past, there are still problems, but these are mainly down to drink/drugs. There are good areas and bad like every city, but it is now not really a violent place, just the usual dickheads you will find everywhere.