SQLServer
Node-Red and MQTT is awesome for real-time data, but what if you want to store and retrieve messages? Its rather straight forward to use Microsoft SQL Server as your database. MSSQL is free and easy to get started with.
MQTT
Detecting Well Liquid loading with, Azure IoT, ML, and Pi
Overview
Legacy IIoT devices can be modernized utilizing edge of network devices to send data to the Azure IoT hub and Machine Learning. This can create cost and efficiency improvements and reduced downtime.
The issue(s)
I will try to quickly explain the issue of liquid loading and slow legacy communications. Keep in mind there are many other issues that can be alleviated with this solution and there is no way I could mention them all. Oil & Gas Wells can “Load Up” with liquid reducing production and possibly incurring costly intermediation to relieve the issue. In the Machine Learning Video at the bottom of this post I go into great detail about this issue.
Read moreDetecting Well Liquid loading with, Azure IoT, ML, and Pi
Custom Cortana MQTT Commands
Cortana can easily be extended to aid you with your DIY home automaton projects. In this example Cortana sends MQTT commands to open and close a garage door as well as ring the doorbell with custom jingles. By the way, you don’t have to use MQTT, you can also do a whole lot of other things as well from opening a file, opening a program, or launching your favorite websites.
As of the writing of this entry I am frantically trying to finish documenting the MQTT Doorbell and Garage Door Opener devices in separate posts. Hopefully I can get those whipped out in a few days.