coconut oil as lube

I’ve heard that it’s good but I’m not sure, apparently it can cause infections? has anyone ever had any experience with coconut oil as lube and how was it?