Curl > json command

[NotoriousBDG]

@Mariusthvdb

the thing is, i started this whole excersize because i want historical data to take me at least one year back, to be able to compare energy usage et all. Purging the DB after 1 day doesn’t help then…

I was led to believe using a real DB like Maria DB should allow me to do so?

In theory it can, but not sure a PI can handle that much data.

@Mariusthvdb

Do you say you use both InfluxDb and Grafana ánd MariaDB?

Yes, I use InfluxDB for historical data. I use MariaDB for state restoration of input_* devices and to give me a little bit of history natively in the Home Assistant UI.

@Mariusthvdb

DO Influx and Grafana take care of the longer period im looking for? If so, how do i set that up, i really really need that priority no.1 right now. Hope you care to share your setup on that.

For my system, the data directory for MariaDB with 1 day of data is 374 MB and the data directory for InfluxDB with 5 months of data in InfluxDB is 534 MB.

If you want to try InfluxDB and Grafana, check out Repository: Bestlibre Addons repository.

@Mariusthvdb

My HA comes to a stand still and runs out of memory when i click history or logbook in the settings. Something must be amiss, and there really should be some kind of safety or security settings to prevent that.

That’s likely because your MariaDB database is so large that the PI is struggling to handle it. If you don’t want to reduce the amount of data, you might want to move to more powerful hardware such as an old PC.

@Mariusthvdb

Im still searching for a way to write the DB to an attached usb stick

Before I moved off of a PI, I used USB Boot on Raspberry Pi 3 - #37 by xbmcnut to run hassio on a USB attached SSD. When I was using it, it performed a lot better than running from an sdcard. In the end, I just have way too much stuff for a PI to handle. I now run hassio on a VM, and the performance improvement is significant.