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;

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:

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

Philips Hue bridge (Zigbee) supported lights

How bright are Philips Hue light bulbs?

Philips Hue offers different ranges of brightness in its smart bulbs so that you can get the perfect amount of light for any room in your home. Use this guide to learn more about lumens and smart bulbs, how to convert from lumens to watts, and how to choose the right brightness.

What are lumens?

Lumens measure how much light the human eye can see coming from light source — the brightness of a light bulb, for example. The higher the lumen rating, the brighter the light appears. This measurement is different from watts, which indicate the input power of a light bulb rather than its light output.

Model 1600 : Up to 1521 lumens

The brightest smart bulb from Philips Hue, this range comes in WhiteWhite ambiance, and White and color ambiance. Light up larger areas of your home, such as the garage or kitchen, with bright light for functional tasks, or dim down to set the mood. This range comes in standard A60/A19 bulbs with E26/E27 bases.

Looking for 100 W? If you want a bulb that’s as bright as a 100 W incandescent bulb, this is your pick.

Model 1100 : Up to 1055 lumens

This range offers powerful light in WhiteWhite ambiance, or White and color ambiance that fully illuminates medium-sized spaces, such as hallways — yet can still be dimmed to a low glow. You’ll find this range in standard A60/A19 bulbs with E26/E27 bases. 

Looking for 75 W? When converting lumens to watts, this bulb is the equivalent to a 75 W bulb.

Model 800 : Up to 806 lumens

The most common Philips Hue brightness, the 800 range of Philips Hue bulbs are available in WhiteWhite ambiance, and White and color ambiance. You’ll see this in the standard shape (A60/A19) and base (E26/E27). 

Looking for 60 W? This bulb is equal to how many lumens are in an incandescent 60-watt bulb.

Read more here