Skip to content

MQTT and raspberry charts in a web page step1

Jump to bottom
Rui Pires edited this page Sep 10, 2020 · 3 revisions

This project aims at documenting an idea I had about having some MQTT stats in a web page. This page is running in a raspberry running apache.

http://g0mesp1res.dynip.sapo.pt/

I already have the MQTT data being shown in my mobile app: MQTT dash. MQTT dash screenshot But I was looking for history. I tried to find a way to collect MQTT is some simple database but all solutions seemed too complicated so I ended up with my own, probably awful, but served my initial intent.

Architecture

Results

http://g0mesp1res.dynip.sapo.pt/raspberry_stats.html (not updated since 8/09/2020) Screenshot below.

Problems

  • crontab fails. I tried several solutions, mostly related to the PATH but none worked. The issue is related to the python app "orca" used to create the charts as a picture.

Future improvements

  • reduce the picture updates in the raspberry as this may cause problems to the SD card.
  • reduce the number and size of the csv files in the raspberry as this may cause problems to the SD card.
Clone this wiki locally