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?

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