Hello,
I have a lot of scripts/tools which reports into my MySQL Database but I need to use scripts with curl to update variables. It would be easier if there is an MySQL Variable device. To display MySQL Information directly.
Thanks
MySQL Variable device
Hello,
I have a lot of scripts/tools which reports into my MySQL Database but I need to use scripts with curl to update variables. It would be easier if there is an MySQL Variable device. To display MySQL Information directly.
Thanks
Any chance for getting it implemented? @mwittig
said in MySQL Variable device:
which reports into my MySQL Database
is this a data base you’ve setup?
"It always takes longer than you expect, even when you take into account Hofstadter's Law.", Hofstadter's Law
Yes it is locally in my raspberrypi where also pimatic is installed and store the data
If you want to read out data do it via php as bash an use shell sensor device.
I am using a php script which updates my variables via curl but it is easier to have it as a simple device
Then i think you have the expertise for development. An MySQL extension is a solution in you MySQL Database via node js into pimatic via plugin. So the easiest way is to get the data out via php… curl is also an option but its better to ask mysql via php for data as send data via curl…
I thought sth.about
SELECT
`nachname` AS variablevalue
FROM testadressen
WHERE vorname = 'Fischer'
And then the first field will be displayed