First thing I recommend is you head over to Potrero/24th and walk all the way up to Mission St. Don't miss Balmy Alley on the way.
you are the media you consume.
You can drink beer on Caltrain, a massive novelty in the States.
But yes, a bike is very convenient :) Europeans think a hundred miles is a long way. Americans think a hundred years is a long time.