Suggested strategy for large database on Raspberry Pi?

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?

1 Like