I am currently storing my HA Data in a MariaDB external to HA. What I am planning on doing is write my Grafana Dashboard to query directly into the HA MariaDB Database. To do this, I want to create SQL Functions/Procedures in the HA Database.
From an HA point of view (architecture / upgrades / etc.) is this safe to do?
I have in the past used InfluxDB, but I want to move off that, hence the use of MariaDB and direct Grafana → HA queries.
Is there a better approach I should be following - for example export specific sensors to a different MariaDB Host using a similar push method used for InfluxDB ?
All thoughts appreciated before I go down this rabbit hole.