Database - Home Assistant states:
The default database that is used for Home Assistant is SQLite
So what other databases can I use and how?
Database - Home Assistant states:
The default database that is used for Home Assistant is SQLite
So what other databases can I use and how?
I’ve been using MySQL (since I already had an instance up for my Kodi library) and it has worked nicely so far.
Another vote for MySQL. When your logs start getting big, SQLite bogs down quickly. Since I moved to MySQL, I can keep a few weeks of data and HA is still faster than it was under SQLite.
I’m actually glad to hear that someone else has noticed a significant speed increase since moving to MySQL. I was worried it just a placebo effect and would eventually fade. But it definitely seems like the initial startup and subsequent restarts are dramatically faster than when my default DB was getting into the bulkier range.
It was night and day for me, and my SQLite db wasn’t that large either.