If you don't really care how you sound in a mix (be it live mix or studio), then it really doesn't much matter.
And if a live or studio mix is really important to you, then you should leave the compression up to a capable sound engineer.
In either case, don't worry about it.
However, if you fall somewhere in between, where you are concerned with your band's live "mix," but you're not at the point where you're rolling with sound guys ... then good, tastefully and skillfully used compression can be absolutely imperative to a good mix. Having dynamics control, in general, over the low end (kick and bass) can be an absolutely indispensable thing for a great live mix. And damn near essential in a studio setting.
As an audio engineer, I wouldn't dream of not compressing the bass. You might think that you have perfect fingers and perfect dynamic control ... but you don't.

Trust me on that one. But I wouldn't trust most bassists to do it themselves, because compression is like a dangerous weapon in the wrong hands, and it can totally ruin an otherwise good sound if you're not using it properly. In the right hands, it's pure sonic gold. Every record that you know and love and have had religious experiences with ... compression is a huge part of it's sound, and there's no getting around that undeniable fact.