If you get in a cover band and need to learn songs quickly/easily, I recommend Constantine Isslamow's youtube channel;
he records himself doing playalongs — no BS pre-amble nor any "2nd string fifth fret with your index finger" — just plays along and you can see what his fingers are doing AND he often includes a link to tab/notation for the song. Downside, he doesn't slap.
For more difficult bits I'll follow his fingering while learning the song on bass guitar, but as soon as I switch to upright I generally prefer to find my own fingering with a lot of open string/first position...
I used to like DK Marlowe, also on youtube, when he didn't speak and just showed you how to play stuff and mimed additional instructions.
Dave Marks (not to be confused with Doug Marks) has some good lessons on youtube. Straight up, no SFX or video magic (IIRC), just some good advice/lessons.
Effects (find the PPCB or other DIY equiv):
#1 — HPF
you'll need some kind of ...
FLANGER. BYZANTIUM or ELECTRIC MISTRESS Clone
Phaser and Fuzz is a classic combo — just ask Larry Graham.
DIRT
What Nostradoomus listed:
Bass Klon,
Black Russian Muff;
Bazz Fuss
Megalith
Barbershop
TS-50B
Acoustic 360 Fuzz
Elka DizzyTone
DOZENS more dirtboxes to suggest...
COMPRESSOR — Milk Box, Engineer's thumb, DIAMOND! and any 1176 clone — make sure it doesn't kill your lows (cough*dyna-ross*cough).
OCTAVE — Octron / OC-2
CHORUS — see flanger above, but yeah I suppose chorus. Caesar. A Double-tracker even better.
EQ! PULTEC EQUILUX, GRAPHIC (just make sure it's centred on bass' freqs not guitar's). UNICAB
FILTER: DUCK BOX, 440, Waddle Box (FX25)
Highly personal and depends on what you like sound-wise and what works for the way you play technique-wise.
Check out the Dunwich pedals, some of which are on Oshpark now and ELSwhere.
Check out the other threads about bass pedals right here on PPCB's forums.
There you have it, a completely incomplete and disorganised set of pedal recommendations that would change on any given day/time/mood...
And a Low Tide, you need a Low Tide...
PS: BOBBY VEGA for funky pick-playing...