srch

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 …

My question is it worth installing mariaDB now version 2 for the ... I started with a 7 day set of data collecting a lot of my sensors that ...

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.

Home Assistant uses SQLAlchemy, which is an Object Relational Mapper (ORM).This makes it possible to use a number of database solutions. The supported database solutions are: MariaDB ≥ 10.3; MySQL ≥ 8.0; PostgreSQL ≥ 12; SQLite ≥ 3.31.0; Although SQLAlchemy supports additional database solutions, it will behave differently on different databases, and features relied on by …

20.03.2019 · I was able to get my db size sensor working using the doc: sensor: - platform: sql db_url: mysql://user:password@localhost/hass queries: - name: DB size query: 'SELECT table_schema "database", Round(Sum(data_length + index_length) / 1024, 1) "value" FROM information_schema.tables WHERE table_schema="hass" GROUP BY table_schema;' column: …

and maybe add some logs to look for to verify it ran? logger: default: warn logs: homeassistant.components.recorder: debug.

Jan 11, 2020 · Configure Home Assistant to use MariaDB. As I mentioned above, the SQLite support that comes out of the box with Home Assistant can only go so far concerning enabling a reliable and scalable database infrastructure for the data collected in your home. For sure, this works fine when you experiment with a few sensors.

Currently my Home Assistant is using the default SQLite database for recording sensor data but I would like to use MariaDB instead.

I'm trying to create a sensor to measure my MariaDB size as per the docs. ... I changed the db name to 'homeassistant' in the query.

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.

May 17, 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.

Sorry, I'm not very good in sql queries… I was able to get my db size sensor working using the doc: sensor: - platform: sql db_url: ...

Mar 20, 2019 · I was able to get my db size sensor working using the doc: sensor: - platform: sql db_url: mysql://user: [email protected] /hass queries: - name: DB size query: 'SELECT table_schema "database", Round(Sum(data_length + index_length) / 1024, 1) "value" FROM information_schema.tables WHERE table_schema="hass" GROUP BY table_schema;' column: 'value ...

I'm trying to set up an sql sensor to get hass.io databse size I am ... the example in https://www.home-assistant.io/components/sensor.sql/ ...

MariaDB ≥ 10.3; MySQL ≥ 8.0; PostgreSQL ≥ 12; SQLite ≥ 3.31.0. Although SQLAlchemy supports additional database solutions, it will behave differently on ...

In mine, homeassistant is the database and hass is the user. This is also different from the SQL sensor page. The Maria DB add-on defaults ...

Sep 15, 2018 · Hi, if like me you followed the example from the mariadb addon page for hass.io to create your DB, you will need to change the table_schema=“hass” to table_schema=“homeassistant” in your SQL. I had the exact same problem until I noticed it was trying to pull info for the wrong DB name.

Set-up MariaDB for Hass.io recorder: db_url: mysql://hass:[email protected]/homeassistant?charset=utf8 # include: # domains: # - sensor ...

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.

08.11.2020 · Hi, through phpadmin, I can connect to the MariaDB database and delete the data of a sensor with this command: DELETE FROM homeassistant.states WHERE ʻentity_id` LIKE ‘% sensor.cputemperature%’ LIMIT 250 Would it be po…

Nov 08, 2020 · Hi, through phpadmin, I can connect to the MariaDB database and delete the data of a sensor with this command: DELETE FROM homeassistant.states WHERE ʻentity_id` LIKE ‘% sensor.cputemperature%’ LIMIT 250 Would it be po…

21.12.2021 · Home Assistant - Setup MariaDB Database Size Sensor Last updated on December 21, 2021 Here I describe how to create a sensor for Home Assistant that will monitor the size of the MariaDB database with a scan interval of one hour. Dependencies. Make ...

Home Assistant is open source home automation that puts local control and privacy first. Powered by a worldwide community of tinkerers and DIY enthusiasts. Perfect to run on a Raspberry Pi or a local server. Available for free at home-assistant.io

For all other cases, add db_url: sqlite:////path/to/database.db . sensor: - platform: sql queries: - name ...

15.09.2018 · Hi, if like me you followed the example from the mariadb addon page for hass.io to create your DB, you will need to change the table_schema=“hass” to table_schema=“homeassistant” in your SQL.. I had the exact same problem until I noticed it was trying to pull info for the wrong DB name.

19.12.2019 · I have excluded all ‘domains’ from ‘data-base’ but the ‘data-base’ is still growing. Now almost 2GB size. I also have some automation - to purge the DB, but looks like it is poorly working. What I have wrong set-up? A…