srch

Feb 01, 2018 · I’m posting this custom sensor in order to get some feedback (improvements and validation) The basic idea is that a sensor retrieves data from an SQL query. My current use case is monitoring HA database size, but I see various other use cases. Please share your ideas 🙂

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

01.02.2018 · I’m posting this custom sensor in order to get some feedback (improvements and validation) The basic idea is that a sensor retrieves data from an SQL query. My current use case is monitoring HA database size, but I see various other use cases. Please share your ideas 🙂

Home Assistant SQL Sensor. GitHub Gist: instantly share code, notes, and snippets.

Database - Home Assistant Database Home Assistant uses database to store events and parametersis for history and tracking. The default database used is SQLite and the database file is stored in your configuration directory (e.g., <path to config dir>/home-assistant_v2.db ); however, other databases can be used.

13.01.2020 · I have several sensors receiving data from an energy monitor that I would like to record in a more efficient and permanent format than the HA database. Primarily because the HA database saves everything as JSON strings instead of the native DB data types which bloats the database by a factor of 100 or so and makes it inefficient to run queries. First thought was to just …

After saving the configuration file and restarting Home Assistant we will be able to edit the interface and add the SQL sensors, Besides, ...

Home Assistant SQL Sensor Raw sql.py This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more …

SQL - Home Assistant SQL The sql sensor platform enables you to use values from an SQL database supported by the sqlalchemy library, to populate a sensor state (and attributes). This can be used to present statistics about Home Assistant sensors if used with the recorder integration database. It can also be used with an external data source.

Sensor Sensors are a basic platform component in Home Assistant. They monitor the states and conditions of a variety of entities. An entity can be many things.

Temperature sensors. Raw data. In a single command we use, in the form of a text string, the SQL query that we want to ...

Database - Home Assistant Database Home Assistant uses database to store events and parametersis for history and tracking. The default database used is SQLite and the database file is stored in your configuration directory (e.g., <path to config dir>/home-assistant_v2.db ); however, other databases can be used.

Home Assistant is configured over its UI and a set of .yaml configuration files. ... Ultimately it should display warnings if the battery of sensors goes ...

Sensor from an SQL Query. Example usage: sensor: - platform: sql. db_url: mysql://user:password@localhost/. queries: - name: DB size.

Feb 10, 2018 · SQL sensor (@dgomes - #12142) (sensor.sql docs) ... From version 0.64, Home Assistant will by default purge recorded state history that is older than 10 days. If you ...

10.02.2018 · SQL sensor (@dgomes - #12142) (sensor.sql docs) (new-platform) ... About Home Assistant. 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 …

Connecting Home Assistant to an external Database Server*** Links ***Hive Mind Automation on YouTube: ...

The sql sensor platform enables you to use values from an SQL database supported by the sqlalchemy library, to populate a sensor state (and attributes).

SQL - Home Assistant SQL The sql sensor platform enables you to use values from an SQL database supported by the sqlalchemy library, to populate a sensor state (and attributes). This can be used to present statistics about Home Assistant sensors if used with the recorder integration database. It can also be used with an external data source.

Since the sql-sensor platform is based on the entity class it's using the default polling interval (30 s). It's possible to change this interval ...

1; Last working Home Assistant Core release (if known): N/A The sensor's ... as soon as the kWh sensor is updated, but the SQL sensor update doesn't happen.

Jan 13, 2020 · I have several sensors receiving data from an energy monitor that I would like to record in a more efficient and permanent format than the HA database. Primarily because the HA database saves everything as JSON strings instead of the native DB data types which bloats the database by a factor of 100 or so and makes it inefficient to run queries. First thought was to just use the SQL Sensor and ...