Basic Intro to MySQL Node-RED Nodes with groov RIO

[@kromhout27]

With the function node i get a error. I think it change after a update of node red. I dont get de Function tab but now there is On Message tab. With var in front the error is gone.
Perfect tutorial by the way.
var raw_time = new Date().getTime();
var timestamp = Math.round(raw_time / 1000);
var watt = "'" + msg.payload + "'";
``
var insert = "INSERT INTO solar (timestamp, watt)" +
" VALUES (" + timestamp + ", " + watt + ")";
msg.topic = insert;
return msg;

[@chickenclips]

Great and informative as always. Thanks

[@Opto22]

you are the best!

[@cernejr]

Is there some text-based alternative to Node-RED?

[@Opto22]

Thanks for watching! Since Node-RED is essentially a wrapper for node.js, you can use node to run your own text JavaScript programs without the web interface on groov EPIC, RIO, and most other systems.
Node-RED also exposes JavaScript code through function nodes.