cUTI has me feeling like a nun!

Apologies if this is graphic, but I'm very fed up with cUTI taking over every part of my life, and this has been the final straw.

I have been married nearly 5 years, and adore the bones of my husband. Sex isn't a huge part of our relationship, but since developing what I suspect is a cUTI a few months ago, the lack of intimacy is really getting to me. He is so understanding, but we both have been open about how much we have missed being intimate and how we wish there was a way we could do that and not have me keeled over with a UTI a few days later.

4 days ago, after nearly 3 months, we had sex. We used a condom and I did everything right before and after to try and prevent a UTI (showering, peeing, drinking loads, d-mannose). Low and behold, got a UTI 3 days later. Also the sex itself was kind of painful (sharp urethral pain) which just killed the vibe. I'm now terrified that I'll get another UTI if I try to have sex again, and I just feel like a terrible wife!

Those of you with chronic UTIs, how do you maintain an intimate relationship with your partner? Anything you have found that helps or things to avoid? I'm not asking for 50 shades of grey, just normal sex, once every week or so, so I can feel normal again!