The character of Sheldon Cooper was inspired by a computer programmer personally known to series co-creator Bill Prady. He is named in honor of actor/producer Sheldon Leonard and Nobel Prize Laureate Leon Cooper.
The infection is caused by bacteria. However, excessive use may irritate you. Soda also dehydrates you, and for proper urinary health you should be drinking lots of water, and also cranberry juice. Your physician was definitely right in telling you that it could have made the bladder infection worse.
An infection in the urinary tract caused by bacteria or fungi can result in cloudy and foamy urine. This is usually accompanied by a burning pain during urination, which is characteristic of a UTI or urinary tract infection. The microorganisms causing the infection produce foam in one's urine.