Last Updated on October 23, 2022 by pg@petergamma.org
- We suffer to have to use Microsoft Access and writing Microsoft Access scripts to access sensor data from a Garmin watch
- our preferred software is Python
- our preferred database is InfuxDB
- Here is another example of a coder which seem to be less stressed:
- Unfortunately, we could not find the code
- But there is one for a sensor from InfluxDB:
- We have a good example from InfluxDB:
https://github.com/influxdata/influxdb-client-python/blob/master/examples/iot_sensor.py
- to access Microsoft Access from Python is very difficult:
- We also have an instruction how to write .csv files into InfluxDB
https://docs.influxdata.com/influxdb/cloud/write-data/developer-tools/csv/
- LibreOffice has also an excellent .csv importer
- maybe from a clear structure as shown here:
- it is easier to import data into InfluxDB
- we already have a lot of interesting option to get sensor data into InfluxDB
- for instance from Polar sensors over MQTT to HA via Polar Sensor Logger app
- with Balena Health to Home Assistant
- we got no straightforward path yet from OpenBCI to InfluxDB
- The easiest way we currently can see is from the WIFI shield Rest API in real-time to InfluxDB by modifying this example:
https://github.com/influxdata/influxdb-client-python/blob/master/examples/iot_sensor.py
- as Krisztián Hofstädter we have great devices to analyse physiological sensor data
- but we miss great tools to analyze those