A dive into MQTT


Its been awhile and that my fault, finding time and whatnot...

I have heard of MQTT and how it is a lightweight protocol that in/will revolutionize IoT communications and have recently had a use for such a mechanism.

I setup Mosquitto MQTT which is an open source MQTT server and it was pretty simple to start sending messages up to the server (called the MQTT broker) and between MQTT clients.

The issue I had was that all this information traversing through the broker was not recorded anywhere. This makes plotting historical data impossible. To achieve this functionality I wrote a crude (very crude) python script to persist MQTT messages to a mySQL database. The code for anyone interested will be located in my bitbucket account.