Building Health Record App with Gemma 4

This is a submission for the Gemma 4 Challenge: Write About Gemma 4

When I discovered the agentic coding I rand out of ideas. Yes despite being a coder and IT experience. I just found myself frozen and can't think of solving any nearest problems at first.

That was upto the point where I saw other people building vibe coding applications one after another. And that triggered me to think of my own problems.

One of the problems I have is keeping track of health expenses and keeping track of health issues. I know there are many apps out there that lets you do that. But none of them were personal.

So I came up with a prompt.

Create an app that let's you record health issues, medicine expenses, doctor visits, health issues and symptoms, medicine consumption streak and insurance data. Use Vite framework and React, SQlite.

Sounds like very generic isn't it? No. If you check I was focused on making use of SQlite to keep my data local. And also wanted to use react to cut down the time.

I used Kilo code and hooked into the Gemma 4. Which you can check in the progress of this app through the video below for the final results.

First step was turning single prompt into an app. Second adding tests to make sure each entry into database and the retrieval for results works. Third making sure the app is usable locally.

So why not hosting on web? As this was personal project so I specifically decided to stay with the SQlite. And so keeping it offline only app. I could use watermelon or similar other database that would help it keep MVP on web.

The final result looks like this.

So where to from here? I can think of creating mobile app or maybe think of making this available through Vercel or netlify hosting. And maybe even opensource this if I could not maintain this myself for long term.