Standards for data capturing / storing
Hello,
Is there a standard, a common way or a system for capturing/storing/grouping the data?
I don't want to reinvent the wheel and would like to use some system that is already used in the field.
For telematic data in agriculture there are DDIs. I am looking for something like that.
https://www.isobus.net/isobus/dDEntity/index
I am building a database where I collect my data from different sources to have everything in one place.
- Apple Health
- exist.io
- Diet
- Workouts
- Habits
- Times working
- ...
Thanks for your help
Sort by:
Best
Open comment sort options
Comments Section
There are standards like FHIR widely used in healthcare, but logging your data this way might be unnecessarily complicated. I currently store all my metrics in a time series database; if I ever need it in a specific interoperable format, I can write code to transform the data from the database as needed. My advice would be to store your data in something simple, like CSV or JSON, until you know what format you might need in the future
What is the database software?
^ this is the answer
the challenge is the timestamps which are always a mess
I have seen lots of data aggregation apps around. You may want to try those first. Besides what u/Surbiglost said sqlite is often used. wiki.openhumans.org/wiki/Finding_relations_between_variables_in_time_series#List_of_less_technical_tools
Recently I was frustrated with the same kind of issues of how to systematically collect personal data that wasn't from an API, trying to make manual entry as painless as possible. So I made this: https://github.com/Qjs/Quanti-tea the goal is to keep a list of metrics active that will export to a Prometheus database over time. Hope you find it useful!