Today I Learned

product

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…

network

Sonos Unifi Pain Resolved, hopefully

This is an update to Sonos UniFi Pain. After crashing my Wi-Fi the other day, I took the…

Astro

Lightweight Excerpts for Astro

How can I easily create excerpts for my content in Astro? That was a question that hit me last week…

macOS

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…

macOS

Open An App Multiple Times

While doing some video encoding for content creation, I wanted to compare different encoding…

macOS

Transcoding Video with FFmpeg and Apple VideoToolbox

Started experimenting with FFmpeg for HEVC encoding using Apple’s VideoToolbox (GPU acceleration),…

shell

Rsync Big Files (over 100gb)

Recently I had to transfer some rather huge files (way over 100gb) around, one by one, using regular…

shell

Poor man's audio stream with FFmpeg

Experimented with streaming setups using FFmpeg, trying RTP and HLS configurations. HLS added some…

product

The Kano Model for Product Development

Today, I learned about the Kano Model, which categorizes product features into “basic” and…

network

Handling Sonos with Unifi

Update: This isn't the latest state of thinking about this. See Sonos Unifi Pain Resolved,…

db

Optimizing PostgreSQL Cache Hit Ratio

Learned to monitor the buffer cache hit ratio in PostgreSQL to ensure efficiency. Aim for 98%+ by…

network

Network Devices for an Attic

A couple of years ago it was quite painful to find networking equipment that didn't cost a fortune…

shell

Creating Efficient Backups with Kopia

For years, I deployed the famous, mature but also unmaintained old Backup gem. Looking for an…

productivity

Delete Empty Days in Logseq

Documenting this as it wasn't quite obvious: I wanted to delete the days from my Logseq journal,…

devops

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…

shell

Proper SSH Permissions

A little reminder for SSH setups: ~/.ssh directory permissions should be mode 700, and…

devops

Integrating UFW with Fail2Ban

I like using ufw, the uncomplicated firewall. I also love to use fail2ban to secure SSH, nginx…