Confusion about documentation / database / sqlite / HA blue

[seaes (sander advokaat)]

Hi,

I found on

Database

the following:

---

…

Home Assistant uses database to store events and parametersis for history and tracking. The default database used is Sqlite …

…

To work with SQLite database manually from the command-line, you will need an installation of sqlite3 …

---

My questions:

• are sqlite and sqlite3 2 different things?

• which is standard in the Image (installation)?

• and which of them is standard on ‘Home Assistant Blue’?

Thanks in advance,

Sander

[Burningstone]

@seaes

are sqlite and sqlite3 2 different things?

No, sqlite is the program and sqlite3 is version 3 of the sqlite program.

[Mutt (Muttley)]

And

@seaes

Home Assistant Blue’

Is merely one possible hardware platform that you can run HA on

[m0wlheld (Christoph Dahlen)]

@seaes

• which is standard in the Image (installation)?
• and which of them is standard on ‘Home Assistant Blue’?

Home Assistant Blue is just an HA appliance running Home Assistant OS, so I assume that sqlite3 is used by default. As with every instance of Home Assistant, you can choose alternative database backends, like MariaDB.