The supernova rate in the solar neighborhood