I have some devices, notably the Zooz Z-Wave Powerstrip that like to over-share data. My database gets huge, my log-file gets huge, and any operation with these files takes forever or times out.
Right now I’m using hass.io, so I can’t see any easy way to manually trim the database. (Even after a reset, SQLite Web just returns 502: Bad Gateway.) Anyone found a good option that allows me to stay in the easier hass.io world?
Thanks, that could work for the database. I’ll give it a try.
What I’d really like is the ability to easily run a script against the database to trim or condense the items. But I can’t install sqlite3 on hass.io except as a web plug in that doesn’t work for me.
It doesn’t need to be installed on HassIO. You can install it on any machine and connect to the database file on your server, via smb/sshfs/sftp/scp…
Thanks, I hadn’t tried that. I set up a share and did the sqlite3 command line that way. Most of the queries seem to come back with “database disk image is malformed.” Just seems like too much data for sqlite maybe.