Today I Learned
STDEV.S vs STDEV.P
In Excel there are quite some functions that have a .S or .P at the end, like STDEV.S and STDEV.P. I…
Sonos Unifi Pain Resolved, hopefully
This is an update to Sonos UniFi Pain. After crashing my Wi-Fi the other day, I took the…
Lightweight Excerpts for Astro
How can I easily create excerpts for my content in Astro? That was a question that hit me last week…
Analyzing Disk Usage
Every so often I have to clean up my laptop's storage. I was a big fan of CleanMyMac's Disk Usage…
Open An App Multiple Times
While doing some video encoding for content creation, I wanted to compare different encoding…
Transcoding Video with FFmpeg and Apple VideoToolbox
Started experimenting with FFmpeg for HEVC encoding using Apple’s VideoToolbox (GPU acceleration),…
Rsync Big Files (over 100gb)
Recently I had to transfer some rather huge files (way over 100gb) around, one by one, using regular…
Poor man's audio stream with FFmpeg
Experimented with streaming setups using FFmpeg, trying RTP and HLS configurations. HLS added some…
The Kano Model for Product Development
Today, I learned about the Kano Model, which categorizes product features into “basic” and…
Handling Sonos with Unifi
Update: This isn't the latest state of thinking about this. See Sonos Unifi Pain Resolved,…
Optimizing PostgreSQL Cache Hit Ratio
Learned to monitor the buffer cache hit ratio in PostgreSQL to ensure efficiency. Aim for 98%+ by…
Network Devices for an Attic
A couple of years ago it was quite painful to find networking equipment that didn't cost a fortune…
Creating Efficient Backups with Kopia
For years, I deployed the famous, mature but also unmaintained old Backup gem. Looking for an…
Delete Empty Days in Logseq
Documenting this as it wasn't quite obvious: I wanted to delete the days from my Logseq journal,…
Updating SSL Options for Nginx with Let’s Encrypt
Finished setting up a new server and wanted to check SSL/TLS quality, using SSL Labs. Noticed that…
Proper SSH Permissions
A little reminder for SSH setups: ~/.ssh directory permissions should be mode 700, and…
Integrating UFW with Fail2Ban
I like using ufw, the uncomplicated firewall. I also love to use fail2ban to secure SSH, nginx…