All are excellent examples of things that would make great hobby databases.

Hey Rudolpho, I have been contemplating the MedicationDB myself as I get older. I have been mapping out Medication info. to included Refills left, Exp dates, Prescribing Doctor, Quantity on hand with locations, How Delivered/Acquired. Then I have been considering Contact info for Doctors and Pharmacies. I know I over think stuff!! But wait, what if after the next segments of Richard's FitnessDB I could also track my personal medical record on my phone as my brain deteriorates with age and complexity of medical conditions. BOOM! Just some thoughts! Don't Stop the Fitness Richard!! Aliens across the galaxy are watching and getting healthier by the Tech Help Videos!!

Dave, I was thinking the same thing... Richard should do a Medication series next! :)

Okay, well, help me out here. As someone who doesn't need to take medication on a regular basis, I mean I take supplements, but I don't need any required prescription medications. What are important data to monitor, such as dosage, number of pills, how frequently it needs to be taken? What do you guys need to track?

From ChatGPT

Here's a list of the main things a Medication Database typically needs to track:
*Medication ID (unique identifier)
*Medication name (generic and brand names)
*Dosage form (tablet, capsule, injection, liquid, etc.)
*Strength (e.g., 500 mg, 10 mL, 20 units)
*Route of administration (oral, IV, topical, etc.)
*Frequency / schedule (e.g., once daily, every 8 hours)
*Start date
*End date / duration
*Prescribing provider
*Patient ID (who it is prescribed to)
*Indication / condition treated
*Quantity prescribed
*Refills allowed
*Pharmacy / dispensing location
*Lot number / batch number (for recalls)
*Expiration date
*Inventory on hand (if you're managing stock)
*Allergy or contraindication flags
*Side effects / adverse reactions recorded
*Compliance / adherence notes
*Special instructions (e.g., take with food, avoid alcohol)
*Insurance / billing codes (optional, for healthcare systems)

I have a database that definitely needs tweeking, and I also track the doctor visits and upcoming visits, and results of the visits, and what proceedures were done, and their results, with the option for a link to supporting documents.

Whoa, this database could get seriously serious. I could see tracking drug interactions too. Like, if you put in there, you take drug A, have it look at the other drugs you're taking, and if it sees drug B which is known for side effects. Then again that might be something better off with an AI search, though. Like, "Hey, I'm adding this drug, does it have any known interactions?" Because keeping all of those interactions in the database would be a professional-level job lol.

Dave Clark, Sandra TruaHoly cow what a huge response I was just asking about taking aspirin lol, thank you very much Dave Clark, Sandra Truax, Kevin Robertson Richard Rost. Wow that is some incredible feedback.
It looks like Mr. Kevin pointed out everything. Also, I might add about topical creams. But that might be only here in California. You know we are different lol. But wow what a great start.
And Sandra, the addition of visits but as well as any procedures that need to be done and the results. Future appointments and other fun stuff.  I love the fact that you would like to add supporting documentation that would be great too.
Of course, Richard, it's seriously serious DB for sure. A huge thank you for letting me know about posting stuff here in the forum a lot of great stuff out here and many thank you to everyone That has given me some great ideas. Looking forward to seeing what lies ahead.
x and Kevin Robertson

If you are going to do the interactions, you may want a drug class like PPI or SSRI.  You also might need an avoid table for the things you are to avoid when taking a given medication, like SSRI's, PPI's, cranberry juice (warfarin), or grapefruit (statins).  

The side effects would be useful to minimize the use of new medications to treat side effects of existing medications.  An AI API would be useful to retrieve things like side effects and interactions.

This would surely be wanted with web access, to be viewed at the doctor's office.

Hey just a couple of cents from me. I use a simple database to track blood pressure, heart rate, and glucose. I track each these things from home.

Kim, I glad you mentioned that because I was tracking my blood pressure also, and probably should still. I know mom has to take her's multiple times a day because she has an inoperable condition and they want to monitor it closely.

Yeah, I check my blood pressure once a month with a home blood pressure cuff, one of those ones you get from Walgreens. But about a year ago, the last time I had a physical, my blood pressure was on the high side, like 150/100 or something along those lines. My doctor actually prescribed me some high blood pressure medication, but I told him I was going to try to correct it with diet and exercise.

Lo and behold, a year later, after cleaning up my diet and getting some exercise at least 3 or 4 days a week, my blood pressure is down into the normal range. I just did it last weekend, and I was 125 over 80, so yay me!

Richard Way to go! I've been put on high blood pressure meds recently, but I think a lot of mine is stress-related because I've never eaten right or exercised enough. That's fixing to change, though. It's getting cooler outside, so I'll be catching up on yard work - or at least that's what I keep telling myself. I have a tendency to put it off because it's either too hot or too cold. LOL.

Sandra - Yeah, that was always my excuse when I lived in Buffalo, that, "oh, it's too cold to go out and exercise." And I used to do it. I used to get dressed up and go jog in the middle of winter. And I hate jogging and I hate the cold. So that tells you the level of dedication I had back then.

But honestly, the best thing that works for me is when I discovered lifting weights, and you don't have to pretend like you're going to be Arnold Schwarzenegger. Just get a couple of lightweight dumbbells and do some simple exercises. It's not hard to do. Like 5 exercises are all you need.

And the best news is it doesn't matter what the weather's like outside. Like here in Florida, it's too hot this time of year to go outside and do anything. I like riding my bike or going for walks with the dogs, but it's muggy and humid. But my garage (which is my de-facto gym) is air-conditioned, so I'm all set. And of course, I've got a pool. That always helps.

I have a stationary bike too, but I just really hate indoor cardio. I even tried watching TV at the same time. Nope. Still boring. LOL