I suspect this will be more than you want to know, but here goes:
I have a condition called medullary sponge kidney. My kidneys have little pockets where urine accumulates and crystallizes into stones (renal calculi if you want to get fancy). The function of my kidneys isn’t affected, thankfully, but if you look at a scan of my kidneys it looks like a starry night, with each star an embedded stone. I’ve heard a bunch of "Oh my God"s and "Holy cow"s from medical staff looking at my scans for the first time because there are so many stones. Mostly they stay put, but every so often one decides to venture forth and see the world, and I end up in the ER in excruciating pain (much worse than natural childbirth, I can attest to that–one time the ER nurse begged me to quiet down because I was scaring a kid in the next cubicle).
I’ve almost always passed them quite quickly–several times while still in the ER. I did have lithotripsy once when my urologist spotted a large stone that seemed about to cause trouble and wanted to break it up first. That left me home for a couple of days passing the pieces, which were small enough to not merit an ER visit, but large enough to cause significant discomfort, so I won’t go that route again. At any rate, I never know when I’ll have another attack, and I just hope it won’t be when I’m away from home. It’s my own personal sword of Damocles, and I’ve just learned to live with it because I have no other choice.
As for pain relief, the med mentioned above, Ketorolac, a super strength NSAID, is truly a miracle drug, with none of the side effects of other pain relievers. I’ve gone from writhing in agony to chit chatting merrily with the nurse in a matter of minutes after having it injected into my IV. Unfortunately, I’m now on an anticoagulant for life (for an unrelated condition), which is contraindicated with any NSAID, so the last time I was in the ER they gave me ever increasing doses of morphine, to no avail. Turns out I’m morphine resistant–who knew? So I sure won’t ever develop an opioid addiction, which is nice to know, I guess. They finally gave me a half-morphine half-Ketorolac mix which did the trick.
I’ve been dealing with this stuff for many years and have seen the medical advice evolve. .Early on, I was advised to avoid calcium, which struck me as poor advice for a 30-ish female. Later I was put on Thiazide, a diuretic, which was supposed to fend off the formation of stones. Today my urologist says the only worthwhile approach is to drink lots and lots of water to keep the urine diluted, though in my case I already have so many stones lying in wait that it really doesn’t matter what I do.
So find a good urologist and drink lots of water, and feel free to PM me if I can be of any help.