Hi Opto team, I have one question. You have setup SQL server on AWS; So, so you have used AWS RDBMS service or you have installed MSSQL on AWS EC2 instance?
Great tutorial! I'm just starting with all of this, I am trying to find a way to write to MySQL via node-red my RFID tag on scan. Is there a property in node-red that can trigger a db write when rfid is triggered (USB rfid in my case)?
You will have to run SQL queries via Node red perhaps triggered by a variable in PAC. As soon as you receive your RFID tag code you can trigger a variable that can be read in Node Red. From there you run a MySQL query to post it into a table.
do I always need to be logged into node red to run the program or can I compile the program and export it elsewhere, so that I can run it without needing the use of the internet. As my internet isn't the best but I want to control my I/O relays of my ds3484 without needed to be connected to the internet. Is this something node red is able to do? or does it run on a server-based system?
Node Red runs on the Opto22 EPIC PR1 and AR1 units. You do not need an internet connection to program in Node Red, unless you want to install new nodes.
Does anybody know how to add an MSSQL node when the SQL runs on my local machine? I tried npm install node-red-contrib-mssql but I don't see any MSSQL element under storage? Any idea?
Hi Fernando, I always hit up flows.nodered.org when I have these sorts of questions. Here you will find a full list of Nodes and example flows. There are many for MySQL, not so much for MariaDB... But in this case Googling does show up some options for that database.
Hi Opto team, I have one question. You have setup SQL server on AWS; So, so you have used AWS RDBMS service or you have installed MSSQL on AWS EC2 instance?
great video as always - but can you please show us how to do it the other way round? Pull data from a table in SQL and then post it back into PAC
This is a great suggestion, we'll keep this in mind for future videos!
excellent content brother......keep up the good work...
Thanks a ton
I am using MSSQL node and I frequently get connection closed error. Cant get rid of it. Any idea how do we handle this ?
Please show how to configure MS SQL. I am using SQL 2017 and having hard time configuring it.
Great tutorial! I'm just starting with all of this, I am trying to find a way to write to MySQL via node-red my RFID tag on scan. Is there a property in node-red that can trigger a db write when rfid is triggered (USB rfid in my case)?
You will have to run SQL queries via Node red perhaps triggered by a variable in PAC. As soon as you receive your RFID tag code you can trigger a variable that can be read in Node Red. From there you run a MySQL query to post it into a table.
do I always need to be logged into node red to run the program or can I compile the program and export it elsewhere, so that I can run it without needing the use of the internet. As my internet isn't the best but I want to control my I/O relays of my ds3484 without needed to be connected to the internet. Is this something node red is able to do?
or does it run on a server-based system?
Node Red runs on the Opto22 EPIC PR1 and AR1 units. You do not need an internet connection to program in Node Red, unless you want to install new nodes.
Does anybody know how to add an MSSQL node when the SQL runs on my local machine? I tried npm install node-red-contrib-mssql but I don't see any MSSQL element under storage? Any idea?
got it, command prompt does not work for some reason but if I install from the pallet management then OK
Is it possible to use MariaDb or Mysql Database?
Hi Fernando, I always hit up flows.nodered.org when I have these sorts of questions.
Here you will find a full list of Nodes and example flows.
There are many for MySQL, not so much for MariaDB... But in this case Googling does show up some options for that database.
Thanks for your vdo.
So nice of you
Want you to preview To receive analog value via chip mcp3008. Thank you.
That's NOT mySql that is MSSQL (Microsoft Sql). I do not know how you got those confused
Sorry for the mix up. Thanks for watching