Building an occupancy sensor with a $5 ESP32 and a serverless DB

Re:Building an occupancy sensor with a $5 ESP32 and a server... by qwertox on Monday November 13, 2023 @04:23PM (#38255606)

My alarm clock consists of an ESP32 and has a somewhat big LED-array connected to it (powered by a transistor), a buzzer and a PIR sensor. It doesn't show the time, but buzzes (and flashes) and takes care of slowly brightening the room, or at night slowly dimming it into darkness some time after all the lights have been turned off.

One added benefit I discovered afterwards is that even though the AP is not between me and the ESP, I seem to reflect enough RF so that logging the RSSI provides information not only about when I'm in the bed, but also when I change position at night.

https://imgur.com/a/VixOlu5 (edit: no erotic content despite the warning)

The green one in the middle is the RSSI, the yellow at the bottom the PIR sensor, the top one a mix of the data from my Mi Band 3 plus an annotation of when I was in bed (yes I did spend a lot of time reading news before falling asleep and before getting up)

[ Parent | on HN ]

Re:Building an occupancy sensor with a $5 ESP32 and a server... by picture on Monday November 13, 2023 @05:35PM (#38256316)

What was your stack like for data collection and visualization?

[ Parent | on HN ]

Re:Building an occupancy sensor with a $5 ESP32 and a server... by punkybr3wster on Monday November 13, 2023 @06:03PM (#38256567)

Ditto! I’d also love to know what is being used for the visualizations.

[ Parent | on HN ]

Re:Building an occupancy sensor with a $5 ESP32 and a server... by outworlder on Monday November 13, 2023 @06:12PM (#38256639)

Not OP but the screenshot looks identical to Grafana.

[ Parent | on HN ]

Re:Building an occupancy sensor with a $5 ESP32 and a server... by qwertox on Monday November 13, 2023 @06:19PM (#38256705)

Sent via UDP to a small custom Python server which feeds it into InfluxDB, then Grafana for visualization.

[ Parent | on HN ]

Re:Building an occupancy sensor with a $5 ESP32 and a server... by bayat on Tuesday November 14, 2023 @09:01AM (#38263372)

Very cool! Thank you for sharing this. I would love to see a picture the aforementioned alarm clock setup as well.

[ Parent | on HN ]