hi,
I read on a forum that Groov Epic has sqlite3; Can I create a database in sqlite3 with name “test”, with fields “ds01” and “ds02” and execute an insert from node-red from the epic?
hi,
I read on a forum that Groov Epic has sqlite3; Can I create a database in sqlite3 with name “test”, with fields “ds01” and “ds02” and execute an insert from node-red from the epic?
Yes, but please don’t.
Better approach would be to install one of the following and have your way with it.
http://developer.opto22.com/epicdev/shell/
It sounds like you might want to store data readings taken from Node-RED (which may be from the EPIC or other sources). I would recommend you look at installing Influx DB on another device (Linux box, Raspberry Pi, AWS server, etc.). It’s free, very well supported in Node-RED, and easy to set up. It’s a time series database, so if you are not really interesting in seeing how data looks over a time interval, then I guess another database might be a better choice.