There are multiple ways to get the right value for fail. Some examples:
SUM(success = 0) as fail
SUM(1-success) as fail
COUNT(*)-SUM(success) as fail
)
I just noticed Home Assistant supports Indieauth to get access tokens. That's great! p83.nl/p/1611
#
Very cool to see other people working on Home Automation stuff. I'm not automating much yet. It's more like keeping track of things, like energy usage and temperature. Best project yet was getting a notification when the washing machine was done, based on energy usage measured by a smart plug. That was created with ESPHome.
This post made me think of a thing that I was thinking a few years back, when my grandfather was scanning old pictures. I had no idea who was in these picture, but he could tell me all about it. My idea was a "wiki" where you can upload a picture and make that the center of some discussions. People can then add the location where the picture was taken, who are in the picture and recount stories about it. All with hyperlinks to other pictures and the people. It's great to see other poeple think about this.
