@selfhatred,
Don't let it fester or eat you alive. Given what you describe here, it sounds like a mistake on your part only so far, in that you became too drunk. Your 'friend' seems to have all the trappings of a rapist here, so I agree with Jespah.
Keeping it silent and under wraps would be wrong. It's already giving you a guilt complex. In addition, it might give your so called 'friend' an opportunity for 'blackmail', since he knows what happened, and your SO doesn't. Furthermore, you have no clue if your friend does this with others as well: an STD check might be in order. Finally, if you find yourself spiraling into a depression, counseling might be an option too.