At my church I have used:
1) the church "house pedalboard" which has a tuner, MXR M87 Bass Compressor, and SansAmp Bass Driver DI. - OK. I also have a SansAmp BDDI of my own that I've had for 20 years. Workhorse. Always useable. But never a favorite of mine.
2) Trace Elliot Transit B - I really like this as a simple solution that offers a lot of flexibility in one easy-to-use box. Tuner, 5 band EQ, drive circuit, split-band compressor, effects send/return loop, and a super clean (low noise floor) DI. I've been using this for about a year and my sound engineers really love it.
Full transparency: I did have one situation recently where it just went kaputz on me and I had to quickly go back to the church's pedalboard. After service I hooked the Transit B back up and everything seemed to be fine.
3) My own pedalboard of a Polytune 3 into a Universal Audio 1776 Compressor into an Aguilar Tone Hammer preamp/DI pedal. - BY FAR the best tone I've ever had! The Tone Hammer is known for somehow magically applying "tubey goodness" and warmth without actually using any tubes. The AGS circuit is there for extra dirt (I don't use it, but it's there) and the UA 1176 compressor is just a dream to play! Altogether these pedals cost less than $600 brand new. (I just put them all in a
Sweetwater cart: $567.99 before local tax. Call your SW Bro and I bet you'll get closer to $520-540. Heck, call MY SW Bro Matt South if you don't have your own already.)
I never bothered with compression for nearly 20 years of bass playing, then I started to dip my toe into the squishy waters a couple year ago - first with a Behringer pedal, then some other Amazon stuff, then the white MXR pedal, and then just last week the UA 1176. The 1176 is a WHOLE DIFFERENT WORLD of beautiful compression. I got to use it both at a rock show and then at church over the last weekend, and it is just the most fantastic piece of not-expensive (got it new for $155) gear I have ever used.
Good luck!
Edited to add: I just realized this threadsurrection is from 5+ years ago. Garf.