To Take Time to Use Python and InfluxDB as a Standard?

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