Log

 

A Python script to write acquired sensor data into SQL (MariaDB).

• setup project / repository
• setup MariaDB
• implement logging
  • heartbeat
    • threading
    • queuing (return values from threads)
  • core_temp
  • DHT Sensors
  • BMP Sensors
  • 1w Sensor
• add RPi clock and volts
• add Unix time
• show SQL on website
• build graphs from database
• coffee ✓ ✓
• tea ||

Appearances

• sometimes no INSERT is emitted - a DROP DATABASE relieves - to be investigated
• make sleep global? bad practice - make it a call parameter (silly you)
• eventually the sleep for the DHT Sensors should be increased
• I'm not very satisfied with the unique queues per task. Is there a better way?
• future me - do you understand the code? -> comments
• call parameters are /would be nice for testing
• ping should be permanent
• after reboot occationally database access is rejected and not catched.

---

Prospect

• add further sensors
• validate plausible sensor values
• check bandwidth with RTT
• avg ping time
• use LOG
• log the time a run really takes (tic,toc)
• log unix timestamp

License

see LICENSE