Comments on: SQLite with Node-RED and Raspberry Pi https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/ Learn ESP8266, ESP32, Arduino, and Raspberry Pi Sun, 09 Aug 2020 17:49:56 +0000 hourly 1 https://wordpress.org/?v=6.8.2 By: dave https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/#comment-484877 Sun, 09 Aug 2020 17:49:56 +0000 http://randomnerdtutorials.com/?p=40002#comment-484877 need a follow-up to show how to put the DHT data into the file
and a second follow-up to show how to display the sqlite file as a graph/chart

]]> By: dave https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/#comment-482918 Tue, 04 Aug 2020 01:03:55 +0000 http://randomnerdtutorials.com/?p=40002#comment-482918 click on any of the objects in the debug window.
the expand
1: object
id: 2
temperature: 22
humidity: 48
2: object
id: 3
temperature: 22
humidity: 48
3: object

]]> By: dave https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/#comment-482515 Sun, 02 Aug 2020 23:11:56 +0000 http://randomnerdtutorials.com/?p=40002#comment-482515 press insert :
INSERT INTO dhtreadings(temperature, humidity, currentdate, currenttime, device) values(22.4, 48, date(‘now’), time(‘now’), “manual”)

8/2/2020, 7:00:05 PMnode: 331e0e9f.21ff5a
INSERT INTO dhtreadings(temperature, humidity, currentdate, currenttime, device) values(22.4, 48, date(‘now’), time(‘now’), “manual”) : msg.payload : array[0]
[ empty ]

8/2/2020, 7:11:05 PMnode: 331e0e9f.21ff5a
SELECT * FROM dhtreadings : msg.payload : array[8]
[ object, object, object, object, object, object, object, object ]

]]> By: Bruce Calder https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/#comment-360826 Wed, 03 Apr 2019 18:55:31 +0000 http://randomnerdtutorials.com/?p=40002#comment-360826 Hi Rui,
Your tutorials are always awesome. I followed this one and it works perfectly to insert data from my NodeMCU modules but how can see the data from the command line? I installed sqlite3 but when I start it with sqlite3 I don’t see the node-red data. Thanks!

]]> By: Ray https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/#comment-335375 Fri, 21 Sep 2018 10:20:37 +0000 http://randomnerdtutorials.com/?p=40002#comment-335375 He Rui,

Thanks for the nice examples about MQTT, SQLite and Node-RED.
I was a bit confused about the lack of a t in currenttime but am able to store some values in a db.
I only face one or two problems with Node-RED that I can’t solve.

First I push the insert inject node and get:
21-9-2018 11:54:39node: 6c67fca9.7eeec4INSERT INTO dhtreadings(temperature, humidity, currentdate, currenttime, device) values(19.6, 53.8, date(‘now’), time(‘now’), “manual”) : msg.payload : array[0]
[ empty ]

If I push select (the inject node) the debug window shows:
21-9-2018 11:55:08node: 6c67fca9.7eeec4SELECT * FROM dhtreadings : msg.payload : array[61]
[ object, object, object, object, object, object, object, object, object, object … ]

But if I look with DB Browser for SQLite (on a windows 7 machine) I can see that data is added.
“59” “59” “19.6” “53.8” “2018-09-21” “09:49:29” “manual” (with 2 hours difference!)

Probably a very simple issue.. but where to look. Maybe you have an idea?

Also: I have a sensor that send different MQTT topics:
home/BME01/temperature
home/BME01/humidity
home/BME01/pressure
I can use 3 different MQTT out nodes to see this working in the debug window.
But how do I make it so that I can put these different values in the table? (after add a pressure record to the table of-course)
Any pointers on how to do this?

Thanks,
Ray.

]]> By: Russ https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/#comment-305567 Fri, 16 Jun 2017 18:29:02 +0000 http://randomnerdtutorials.com/?p=40002#comment-305567 Nice job, I’ve been trying to figure this out for a few months now.

]]> By: Parviz https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/#comment-305549 Fri, 16 Jun 2017 10:56:48 +0000 http://randomnerdtutorials.com/?p=40002#comment-305549 Hi Dear Rui,
Thanks For powerful articles, Good job…

]]>