You are afraid of a knife but you aren't afraid of a .452 caliber 250 grain HP projectile going 900+ fps? Strange way of looking at it.
Single Action revolvers are one of least desirable SD handguns, in my opinion. However, they are still formidable weapons and very effective in competent, practiced hands.
"No free man shall ever be debarred the use of arms."- Thomas Jefferson