Hello guys…
I’m trying to add communication with my heat pump - there’s a module available for that who can read/write data to an sql server- would it be possible for OH to read and write data in that database - since it’s another program that also does that? As I understand that should be the benefit with MySQL:)
You won’t be able to do this directly with the mySQL persistence service. The purpose of the persistence service is to record openHAB item data into a database - it can’t query a different database with an unknown schema.
That’s not to say that it can’t be done using a script or something to run a command line option to query the database, just that the persistence service unfortunately can’t do this - hopefully someone will have some ideas of how to help…
Okay, glad you pointed that out - I’ve seen it as when it could do historic on MySQL could it also do anything else 