Solar assistant and Grafana
- Thread starter kelvinfpv
- Start date
pollenface
Solar Addict
What's SA and HA stand for?
MisterSandals
Participation Medalist
Solar Assistant and Home Assistant
I don't, but you could take a look at some of @peufeu's python code...
IIRC he integrated from MQTT to grafana - see...
Solis S5: Various issues
Let us know if it powers up automatically when get PV again. Also, have you measured how much battery consumption reduces by when you put it in sleep mode? Results: Yesterday at midnight, battery SOC was 11%. I turned the inverter off using the GUI. This morning at 8AM, battery SOC was still...
diysolarforum.com
I used Grafana to begin with, but found it cumbersome and hard to configure. So I switched to bokeh.
Grafana doesn't require you to code, so it's easy, but it's pretty dumb. It's a magnificent illustration of Greenspun's Tenth Rule. ie, you don't have to code with your fingers, but you have to code with your mouse instead. So a thing that would take half a page of python, like merging realtime MQTT data and stored data from a database, or mip-mapped materialized views... instead requires reading thick mysterious tomes of documentation about DataTransformations. I don't even know if it's possible. I gave up after a few hours.
Bokeh requires you to code, so it needs a little bit more effort at first, but it is much more customizable.
OK, I looked at SolarAssistant website. Apparently they use influxdb as database to store the data, and grafana for the dashboard. So in this case you can probably copypaste the default grafana dashboard and modify it so it does what you want. Grafana has an editor mode where you can modify everything, you just have to turn it on.
Grafana doesn't require you to code, so it's easy, but it's pretty dumb. It's a magnificent illustration of Greenspun's Tenth Rule. ie, you don't have to code with your fingers, but you have to code with your mouse instead. So a thing that would take half a page of python, like merging realtime MQTT data and stored data from a database, or mip-mapped materialized views... instead requires reading thick mysterious tomes of documentation about DataTransformations. I don't even know if it's possible. I gave up after a few hours.
Bokeh requires you to code, so it needs a little bit more effort at first, but it is much more customizable.
OK, I looked at SolarAssistant website. Apparently they use influxdb as database to store the data, and grafana for the dashboard. So in this case you can probably copypaste the default grafana dashboard and modify it so it does what you want. Grafana has an editor mode where you can modify everything, you just have to turn it on.
I'm pretty dumb to all of this so bare with me. Where do I copy the default dashboard from and then where do I paste it?
No idea. I remember doing it but not how. I only used grafana for a very short time ?
MisterSandals
Participation Medalist
I was a database and sql/sybase expert 30 years ago. Influxdb is a nightmare of hipster terms (buckets and secrets? Wtf) with hideous documentation and tools (user interfaces by drunk interns I suspect).
I have been messing with what would be 2 hours of work to 40 hours of frustration. Still trying tho, sadly.
</rant> //sorry you had to see that
Similar threads
