How MATTER (Smart home standard) works?

All Matter-certified devices in your local area network (LAN) will work smoothly even when your home internet goes offline. Matter allows effective communication directly between devices, without the need for a specific ‘forwarding’ device. For example, a Matter smart switch or sensor can turn on/off a Matter bulb directly without being connected to a cloud service, or other specific action. Once configured, communication and control between Matter devices can be achieved directly on the local network.

https://www.wired.com/story/what-is-matter

What is ESPHome?

ESPHome is a platform developed for ESP32/ESP8266 and is mainly used for Smart Home devices. ESPHome has tons of ready made configurations, libraries and examples. In 2021 Nabu Casa (Home Assistant developer company) acquired ESPHome and integrated the whole ESPHome system more deep into the Home Assistant Core. These days ESPHome can be installed directly from Home Assistant Add-On store and configured from Home Assistant UI!

Bluetooth Proxy is a gateway software that listens for ‘all’ Bluetooth traffic and forwards them to the Home Assistant instance. Basically BLE to WiFi gateway.

Read more here;

Guide: Bluetooth Proxy to Home Assistant using ESPHome

https://blog.kastanis.gr/m5stack-atom-s3-lite-with-esphome/
https://esphome.io/guides/getting_started_hassio
https://esphome.io/components/wifi.html#configuration-variables

SQL Query to get server IP address

Here is how;

SELECT  
   CONNECTIONPROPERTY('net_transport') AS net_transport,
   CONNECTIONPROPERTY('protocol_type') AS protocol_type,
   CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,
   CONNECTIONPROPERTY('local_net_address') AS local_net_address,
   CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,
   CONNECTIONPROPERTY('client_net_address') AS client_net_address

Reference

https://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address#:~:text=To%20do%20this%2C%20create%20a,ll%20get%20the%20IP%20address.

Color Temperature & Brightness Level of Philips Hue Scenes

Assuming we’re talking about the gen 3 A19 white and color ambiance bulb:

SceneColor temp (K)Brightness (lumens)
Relax2237~200*
Read2890~570
Concentrate4291~800
Energize6410~550

*The Relax scene is 56% brightness. Lumens calculated by multiplying brightness at 2000K (342 lm) by 0.56.

And then for the gen 3 A19 white only bulb:

SceneColor temp (K)Brightness (lumens)
Bright2700840
Dimmed2700~252**
Nightlight2700~84***

**Dimmed is 30% brightness. Lumens calculated by this formula: 840 x 0.30

***Nightlight is 1% brightness, but there is no difference in brightness below 10%. Lumens calculated by this formula: 840 x 0.10

Sources:

How bright are Philips Hue light bulbs?
Color Temperatures of Hue Recipes
byu/jpzsports inHue

https://www2.meethue.com/en-us/p/hue-white-and-color-ambiance-single-bulb-e26/046677530211

Philips Hue bridge (Zigbee) supported lights