When comparing SQLite vs MariaDB, the Slant community recommends MariaDB for most people. In the question “What are the best relational databases?” MariaDB is ranked 2nd while SQLite is ranked 3rd. The most important reason people chose MariaDB is:
17.05.2020 · RPi Hassio + Synology NAS Maria DB For logging Home Assistant MariaDB 10 has been updated several times since the original post (currently on version 10.3.21) and there have been a number of minor changes which affect the instructions above.
27.04.2020 · Just in case some HA users come here to find the easiest way to change from Sqlite to MariaDB: It sounds all very complicated in the postings here, but it is actually VERY simple! You do NOT need to migrate any existing data. The data in the HA DB is purged after 10 days anyway. All you need to do is… Install the MariaDB add-on (Supervisor menu).
11.06.2017 · I setup home assistant around six months ago, and I have amassed a sqlite database around 700Mb. Today, the entire six months of history is in the Sqlite database which is causing home assistant to hang for minutes when I try to look …
09.01.2020 · Home Assistant: MariaDB statt SQLite als Datenbank 9. Januar 2020 laoke Kommentar hinterlassen Home Assistant nutzt als Datenbank Backend SQLite. Diese Datenbank liegt im Konfigurationsverzeichnis uns hält zum Beispiel die vergangenen Sensordaten vor, um Grafen anzeigen zu können.
MariaDB is an implementation of MySQL that can handle a lot more data a lot more efficiently than SQLite. If you are having unknown slowdowns with your Home Assistant Instance, or if you are having the display of sensors disappear, this may well be the fix for you. A good way to tell is for you to look at your ‘home-assistant_v2. db’ file.
04.02.2019 · I have gleaned most of the following information from the BurnsHA video regarding migrating Home assistant from sqlite3 to mariadb. I did add a few steps that were not mentioned in his video that were required for my migration. Many thanks to all who have tread this water previously. I am using a Raspberry pi 3 as the HA server running hassbian, and I have done the …