I’m usig openHAB now for about 1 week and I’m very impressed and it makes a lot of fun for me. I think it will be my new hobby
But I have a question regarding the persistance because I’m absolutely undecided by now: As I’m familar with relational databases, I would prefer to use MySQL with Grafana. As I see it seems to work. At the moment I’m using InfluxDB, but honestly I miss the possibility to take a look on the database with something like phpMyAdmin, for doing my own queries, deleting data etc. So the question: Are there any big advantages when using MySQL instead of InfluxDB? Of course maybe the performance, but I think the performance with MySQL is by far ok for me. Are there any restrictions for queries or charts, which can’t be done with MySQL and Grafana?
For a beginner, like me, it seems to be necessary to use InfluxDB, that’s what I read all the time. But I didn’t find any satisfying arguments to use it, instead of MySQL…
Best regars and many thanks in advance