MySQL values to item

Hello everybody,

i have a mysql database, where the values of a number of sensors are periodically stored.
And I like to have these values as items in openHAB.

I have found a lot of explanations about persistence and how to use it, but I have nothing about how to just read the values into openHAB. Or have I overlook something?

Thanks.

No, there is no simple way to read in data from a database. You have a number of options, all of which involve writing an external script or program to poll or trigger off of saves to your database and publishing the new value to OH using the REST API or using messaging like MQTT.

thanks for the answer.

i will try to do it with MQTT.

Might be useful: https://github.com/rkoshak/sensorReporter