Moving Home Assistant’s Database To MariaDB On Proxmox

Alvaro Martinez Muñoz ✅
System Weakness
Published in
9 min readAug 3, 2023

--

By default, Home Assistant records and keeps history in an SQLite database (/config/home-assistant_v2.db) for 10 days, committing changes every 5 seconds and automatically purging every night to keep the file size from growing infinitely.

These setting are okay when you are just starting out with HA, but when you start to deep dive and add a bunch of devices, integrations and addons than tweaking the recorded is needed for a variety of reasons.

--

--

Hi!. I´m Alvaro and i´ll share my Personal projects hobbies like Home Assistant and Linux HomeLabs. I hope like my Posts and support me with little beer 🍻