Pops rosin is a very popular choice, it leans towards sticky. It is good for students and professionals alike. It comes in a convenient plastic cup with a sealing lid. You definitely don't need much, just a little dab (a couple swipes) will be enough.
Softer rosins like Pops are handy to have for when your playing environment is cold and/or dry, when a harder rosin just isn't "grabbing" enough.
Pops Bass Rosin