Topic: Track your blood sugar !
Hello everyone,
I've updated one of my old projects for tracking blood sugar levels (type 2 diabetes) with data entry and graphing.
It does the basic job; the table is incremented via an Add button.
But I'd like to improve it further.
Essentially, I want to be able to separate the table (sqlite.db) into various elements
by year. This allows the user to view their data entries according to the year of their choice, and the graph is updated accordingly. I found an excellent Sparrow program on the forum that did what I'd like to achieve: split the general sqlite.db file into as many files as there are years, which would result in something like: (2023 -> sqlite.db), (2024 -> sqlite.db), and so on, i.e., assign a given year an sqlite.db file containing only the data specific to that year.
Unfortunately, I'm unable to find his project, and especially his method for
splitting the general sqlite.db into as many small sqlite.db files specific to each year (perhaps with SQLStudio?).
I would be very grateful to anyone who could help me make this improvement.
I've already entered the data by year (.csv format, perhaps not the most appropriate?).
Note: I'm freely making this project available to anyone who, like me, would like to track their own blood sugar. You can modify it, add new features, and do anything you can to improve it. In exchange for feedback on your own improvements.
Thanks in advance
JB