Counting a word across Signal messages with the macOS keychain
I wanted to count how many times I'd used a specific word across all my outgoing Signal messages. Sounded like five lines of SQL. The interesting part…
Read →BLOG · PAGE 17
Page 17
A BYOS e-ink dashboard that wakes once a day
I wanted a tiny always-on display in my office that showed the day's useful information and lasted a season on a single battery charge. The constraint…
Read →Sketching a one-click honeypot installer
Honeypots are useful and almost nobody runs them, because the existing stacks are either too heavy (multi-container threat-intel platforms that need 16…
Read →Memex — a queryable second brain over my messages
I wanted to ask my own data questions like
Read →Adding email to the Memex (and a Dynamo pagination gotcha)
A few hours after shipping the Memex over iMessage and Signal, I added email. The interesting part wasn't the feature — it was a DynamoDB pagination bug…
Read →Per-day-of-week sleep windows for a safety app
A safety app I run was firing
Read →Five identical schedules, thirteen SMS in ten minutes
09:33 to 09:43 on a Friday morning: thirteen SMS messages, several push notifications, all from my own safety app, all to me. The trigger was five…
Read →Decrypting Signal Desktop's database on macOS
I wanted Signal Desktop's message history available for indexing in my personal search. Signal Desktop stores messages in a SQLCipher database, and the…
Read →Teaching the arrs to skip Russian and very long releases
Sonarr blew up at 3 AM with PathTooLongException thrown across the import queue. The release that triggered it was a translated upload with a…
Read →94% SpO2 is not an emergency
I got a high-severity SMS from my own safety app:
Read →When Sonarr's UI hangs after a restart, blame the WebSocket cache
I'd just restarted Sonarr to recover from an unrelated issue. The service came back up, API requests responded fine, but the web UI in my browser was…
Read →Sonarr was dead because of a Cyrillic filename
Sonarr's web UI was unresponsive. systemd said the service was active (running). The process was using 100% of multiple cores. Load average on the…
Read →Why the sleep-window learner kept collapsing to the wrong four hours
The v1 sleep-window learner for a side-project safety app produced a sleep window of 01:00–05:00 for me. My actual sleep is more like 23:00–07:00. The…
Read →A risk email every fifteen minutes about nothing
The risk-monitor cron on a side project I run was emailing me every 15 minutes with
Read →