Home assistant

https://www.awesome-ha.com/ config energy
https://wiki.ip2u.ru/smart-home#home_assistant - multiroom

HAAS HAOS install on armbian additional HAAS addons repository
in docker HA right docker old Smart home Russia HA on armbian in docker
in proxmox HA in proxmox 8
in openwrt install HA on openwrt https://github.com/openlumi/homeassistant_on_openwrt

открываем домофон https://habr.com/ru/articles/533812/

https://www.home-assistant.io/integrations/ubus/

Xiaomi - 
>>> Solution >>>
I have create via ES-FileExplorer a file /config/wifi/mac.txt with the wish MAC-Adress with chmod 444 permissions and it works !!!!
<<<Solution <<<

10A2ABxxxxxx - without double point

https://docs.scrypted.app/installation.html – scrypted install docker
https://www.homeautomationguy.io/blog/running-frigate-on-proxmox – frigate install docker on proxmox
https://coral.googlesource.com/webcoral/ - TPU accelerator coral start

example http://kvazis.link/hassos
icons https://pictogrammers.com/library/mdi/ https://mdi.bessarabov.com/icon/memory

https://www.youtube.com/watch?v=MCNxgb0mrSA

https://sprut.ai/user/AlexAz/contents/articles

Get stats of mysql - where data located

-- get count of state entity and count of history data
SELECT 
    states_meta.entity_id,
    COUNT(*),
   -- states.state,
    from_unixtime(MIN(states.last_updated_ts)) AS last_updated_ts,
    from_unixtime(MIN(IF(states.last_changed_ts IS NULL,
        states.last_updated_ts,
        states.last_changed_ts))) AS last_changed_ts
FROM
    states
        LEFT JOIN
    states_meta ON (states.metadata_id = states_meta.metadata_id)
GROUP BY states_meta.entity_id
ORDER BY 2 DESC
LIMIT 10;
 
-- size of all tables
SELECT table_schema AS `DB`, TABLE_NAME AS `Table`,TABLE_ROWS, 
  ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` 
  FROM information_schema.TABLES 
  ORDER BY (data_length + index_length) DESC;

# home assistant - executing in day 24h
01h 	24
10m 	144
05m 	288
01m 	1440
05s	17280
01s	86400
 
{% set result = namespace(sensors=[]) %}
{% set exclude = [] %}
{% set hours = 1 %}
{% for state in states.sensor | rejectattr('attributes.device_class', 'undefined') | selectattr('attributes.device_class', '==', 'timestamp') %}
    {{state}}
    {% if 'last_seen' in state.entity_id and not state.entity_id in exclude.entity_id and (states(state.entity_id) == 'unavailable' or ((as_timestamp(now()) - as_timestamp(states(state.entity_id))) > ((hours | int) * 60 * 60))) %}
     {% set result.sensors = result.sensors + [state.name | regex_replace(find=' last seen', replace='') ~ ' (' ~ relative_time(strptime(states(state.entity_id), '%Y-%m-%dT%H:%M:%S%z', 'unavailable')) ~ ')'] %}
    {% endif %}
 {% endfor %}
 {{ result.sensors | join(', ') }}