Node-RED Windows10 Install

Node.js download

Node.js install

npm i node-red

node node_modules/node-red/red.js

http://127.0.0.1:1880

---

SQLite ノードの追加　(パレット設定から)

---

ダッシュボードの追加

Node-RED ノードを追加

Text input  を追加

https://qiita.com/takeyan/items/fff5e8d64da25220a0c0

---

tab

node-red-das

ノードを追加

text input

SQLite3 test

CentOS8

mkdir /usr/s3db
cd /usr/s3db
sqlite3 testdb1.sqlite3
create table test_tbl (id, name);
insert into test_tbl values(1,'centos');
insert into test_tbl values(2,'Windows');
insert into test_tbl values(3,'ios');

insert into test_tbl values(4,'Andoroid');

insert into test_tbl values(5,'Dbian');

select * from test_tbl;

select * from test_tbl where id = {{payload}};

.q