As discussed here, I’ve started rebuilding my Home Assistant instance with Docker containers on a N150 NUC after using HAOS exclusively on RPi’s for the first 3 years. A big reason a single micro SD card lasted this long was because I reduced the number of recorded entities using the Recorder integration*. Before I re-integrate everything in my house, I want to make sure I’m starting with the most optimum DBMS available in 2025.
I know the standard SQLite implementation has improved much over the last couple years and many have chosen to migrate back from MariaDB. So, at a minimum maybe I’m looking for confirmation that the default database is the gold standard now. If you disagree, what DBMS do you use and why?
*I am not looking forward to doing this again and hope this WTH gets implemented soon!
Edit 1 - I added a related poll to the Facebook Group here