Choosing the right type of database

Hi, just moved from OpenHab2 to Home Assistant. Installed on a RaspberryPi 3 booting from and running of USB stick. Besides Raspbian and Homegear, HA is the only application of importance on that RPi.

After having things set up and automation working, I finally want to replace SQLite by a “real” database. I have experience with MySQL, PostgreSQL and Oracle, but I am also curious about time-series databases like InfluxDB or Graphite.

In the context of Home Assistent and with the the limited space of a USB stick in mind - is one of these DBs better than others?

1 Like