I’ve been running HA now for a while now on a RPi 3 and the local sqlite DB has grown to 1.4GB, making it difficult and ungainly to access. Can anyone suggest a strategy for handling this? I’d like to retain the data for analysis so pruning isn’t ideal, but I’d like to have decent speed access to history.
Suggestions?