Peter Stuifzand Notes on software, small tools, and the open web.

Tagged replies

16:56

There are multiple ways to get the right value for fail. Some examples:

→ aaronparecki.com/2022/09/16/6/sql

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

06:09

Very cool to see other people working on Home Automation stuff. I'm not automating much…

→ aaronparecki.com/2019/08/18/27/iot

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.

06:18

This post made me think of a thing that I was thinking a few years back, when my…

→ ramblinggit.com/2018/12/family-lore-memories-and-a-wiki

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.