Is there any guidance on what s the best database to use for Home Assistant?
My install is HUGE and been running for close on 8 years now… I moved to Maria years ago, but of late, all the glitches are now becoming more than an inconvenience.
With the latest update, my HA simply keeps restarting with nothing in the logs…
I was under the impression that something like Postgres would be the “Most powerful” but after reading this, it looks like SQLlite is now the flavour of the month?
I am not a DB guy, but lets assume:
- Storage is irrelevant
- Processor/RAM is irrelevant
- I have close on 5000 entities in my HA
What DB should I be using? I know this may draw a lot of “Well it depends…” responses, but my question is simple…
What is the best performing DB setup for HA… Timescale even or back to SQL Lite?