I recently installed Home Assistant on a Lenovo Thin Client with an Intel i3 processor and 8GB of RAM. It’s been a fantastic experience so far, running smoothly with low power consumption. I decided to make use of the 128GB SSD by configuring HA to store a significant amount of historical data, but I have a few questions about optimizing this setup.
First, I’m curious about the best database to use for long-term storage. Currently, I’m utilizing the built-in database, but I’ve come across recommendations to switch to something else. Given that disk space isn’t a concern (I can easily upgrade to a 2TB drive if needed), I’d love to hear the community’s thoughts on which database would be most suitable for handling extensive data retention.
Second, I’d like to find a way to monitor how much data is being consumed. I’m familiar with SQL databases, so ideally, I’d love a tool similar to what I use for managing Microsoft SQL Server. Right now, I’m not sure if I’m using 100MB or 100GB of storage, and it would be incredibly helpful to have a clear overview.
Lastly, assuming my database is relatively small, how can I increase the retention period for my data? I’ve noticed that I can only access about 10 days of history for certain sensors, like my fridge door openings or temperature probes. While I have yearly status updates for energy consumption, it seems calculated, and I can only view hourly data for the past 10 days. Extending this retention period would provide more comprehensive insights into my energy usage patterns.
I’d greatly appreciate any advice or step-by-step guides the community could offer. Thanks in advance for your help!