Hello all. First I’ld like to say that I love the tutorials by RandomNerdTutorials. Because of it i’ve learned a great deal and finally gained some traction in my projects in coding on my own.
One thing that I think would really supplement RNT is a tutorial on taking sensor data from MQTT and injecting it as a new row to SQLite3 using node red. The closest thing to it is a tutorial using python. I have duplicated both of the tutorials by RNT (publishing to sqlite3 by inject node only) as well as the tutorial on subscribing to sensor data with MQTT using an ESP8266.
Would someone be willing to help me on understanding how to bridge MQTT sensor data to SQLite3 using node red?