Every time I add a device to my MQTT network, I need to do something with the data.  Typically, this is just capture the message, extract the fields and write it to the database.

This is simple, but tedious – create the database table, create a service to listen for messages, parse the message, build a query to write to the database.

So I built MQTT Processing as a generic event handler for MQTT Messages…

  • Capture any MQTT message type (currently limited to JSON payloads)
  • Do anything with the data (currently limited to writing to a database)
  • Create and update the tables for the data (currently limited to creating only)
  • Works on any database (currently limited to MS-Sql Server – includes express and development versions)
  • Runs on any platform (currently only windows supported).
  • Interactively capture an MQTT message and configure event handler (all the above supported).
  • Run as a service

Full details can be found here – Github MQTT_Processing

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.