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

Node-RED Library

https://flows.nodered.org/

Node-RED MS SQL Server

https://flows.nodered.org/node/node-red-contrib-mssql-plus

簡単

node-red内のメニューから[パレットの管理]> [インストール]オプションを使用します

---

または、Node-REDユーザーディレクトリ（通常は?/ .node-red）で、

npm install node-red-contrib-mssql-plus

node node_modules/node-red/red.js

127.0.0.1:1880

Node-RED PostgreSQL

https://flows.nodered.org/node/node-red-contrib-re-postgres

インストール

Node-REDインストールのルートディレクトリで次のコマンドを実行します

npm install node-red-contrib-re-postgres

node node_modules/node-red/red.js

127.0.0.1:1880

https://flows.nodered.org/search?term=postgres

Node-RED SQlite3

Node-RED SQlite3

https://qiita.com/khara914/items/a7176c3f54bd54ca6eee

https://flows.nodered.org/node/node-red-node-sqlite

npm i --unsafe-perm node-red-node-sqlite

cd ~/.node-rednpm rebuild

Node-red

https://qiita.com/joeartsea/items/93e8483a31292067c654

npm i node-red

node node_modules/node-red/red.js


http://127.0.0.1:1880