I'm trying to break down where my household electricity usage goes, and lighting is one rather difficult to quantify since there are many devices that have somewhat irregular usage patterns. To alleviate this, I wrote a script to query the Hue (compatible) bulb brightness from the Hue bridge, convert this to power via brightness-to-power calibration curves, and store this to InfluxDB.
Although I've managed to get WiFi connection in most corners of my house, I still had limited signal in my garden ('for one of those days you can squint your eyes in the sun trying to read the screen', a friend joked). Although this situation rarely happens, I still like to fix things in theory sometimes
I wanted to place my router somewhere not in the meterkast, so I used VLAN tagging on a managed switch to get the WAN data to the router and my LAN data back on the same wire (but different VLAN) to distribute to the rest of the house.
Although most of us (including me) are familiar with making our own network cables/jacks, I recently wired network cable in my house learned some new things/abbreviations on cable thickness, cable material, pin termination, cross-over vs straight cables. I document my findings here for reference and case I forget in the future