Write to database options

[Dweber85rc]

I use mySQL and MS SQLServer for mcsSprinklers so that part is easy to add. My thinking is that existing UI for external database would remain intact and there would be a global setting for which external database would be used. Is this something like you were thinking?



I do not understand what is being requested. Currently mcsMQTT will write changed DeviceValues to an internal (SQLite) and/or external (InfluxDB) database for any HS device that has been selected for routing to the database. There is no dependency on a device being created by mcsMQTT. There is also a history capability to store MQTT messages to internal database. Obviously MQTT messages need to be routed through mcsMQTT to accomplish this.

mcsMQTT also supports a scripting interface so that anything that is being done by mcsMQTT can also be done using scripting.

Can you clarify your request?

For the first question, Yes that is what I was inquiring about. Similar to the options currently to write to SQLite or an external InfluxDB.
For your 2nd question I think your explanation answered my question. I was looking to be able to send, for example, energy data from a zwave outlet to this mysql database as well, which from your explanation sounds like it is possible. My goal here is to eventually get Granfana going, which can use mysql data sources, and again try to avoid having a separate database server for this since I have one that is pretty much snoozing all the time.

[Michael McSharry]

I use mySQL and MS SQLServer for mcsSprinklers so that part is easy to add. My thinking is that existing UI for external database would remain intact and there would be a global setting for which external database would be used. Is this something like you were thinking?

Also wondering about how/if there would be a way for a non mcsmqtt device to write to said database through mscmqtt?

I do not understand what is being requested. Currently mcsMQTT will write changed DeviceValues to an internal (SQLite) and/or external (InfluxDB) database for any HS device that has been selected for routing to the database. There is no dependency on a device being created by mcsMQTT. There is also a history capability to store MQTT messages to internal database. Obviously MQTT messages need to be routed through mcsMQTT to accomplish this.

mcsMQTT also supports a scripting interface so that anything that is being done by mcsMQTT can also be done using scripting.

Can you clarify your request?

[Dweber85rc]

Wondering if it would be possible to add support for writing values to a mysql/mariadb instance? I already have a mysql/mariadb server on an rpi on my network so wondering what would be possible without adding a separate server for influxdb since the other application using mysql does not support influxdb. Also wondering about how/if there would be a way for a non mcsmqtt device to write to said database through mscmqtt?