History database where do I find it please?

Configuration
1

Please can someone tell me how I find the history database file as i cant see anything called “home-assistant_v2.db” and there also does not appear to be a recorder: header anyware in my config files

2

The recorder integration is automatically enabled if the history integration is enabled and the history integration is part of the default_config option, which you probably have in your configuration file.
You can add the recorder option, if you want to do some filtering or other setups.

The home-assistant_v2.db should be there, but some views hide it, like the VS Studio Code Server.
In VS Studio Code Server it is possible to find it if you choose open file and then type /config/home-a
I am not sure it is readable as a common text file though. You might need a SQL connector to get the an output that is understandable.

3

It is in the config folder, same place as configuration.yaml, see Configuration.yaml - Home Assistant

4

yes I think you are right its vs studio code hiding it, I can’t work out how to show it as the search also does not find it

is there a better way at see the hidden file I want to know how big it is please

5
6

oh ok thought there would be more of a gui interface

7

Just make sure you don’t even think of writing into that file, because it will immediately “become corrupt” from HA’s view and it will start a new database while you’ll end up loosing all history. Sqlite is very picky about this - only one user is allowed to “be logged in” and alter database at a time, and if that “one” won’t be HA it will, as said, start a new blank file. I played with that once and connected to database file with third-party software and history was immediately lost.
Your best (safest) option is to use HA’s addon (sqlite web), or make a copy and play with copy instead.

8

thanks, was not interested in play with it just wanted to know what size it was and where to check if I changed the number of days history it holds! (playing around with the recorder settings)

9

I’m using the “Samba share” AddOn for easy accessing the files.
To see the filesize directly in ha i’m using the “File size” integration.

10

I’m using the “Samba share”

…yep, that’s how i destroyed my sqlite database back then…using samba to connect to database with third-party sql software…:crazy_face:

11

File size works perfect thanks

1 Like