Lube confusion

What’s the difference between water based and silicone based lube? Are there times where one should be used over the other?