It seems to be feasible to actually hit a target at a useful range (7 yards would beyond my stabbing range, even with my big knife ;))
https://www.youtube.com/watch?v=eB-vaGV8wy0

Here is a demo on this gun and few other small handguns:
https://www.youtube.com/watch?v=cSw28CxlmgI

or if something slightly bigger is OK:
https://www.youtube.com/watch?v=cdxKZzRi-JI