writer://
January 19, 2025
Concurrency vs Parallelism
Concurrency is handling multiple tasks during the same time. Parallelism is actually doing tasks at the same time. For concurrency, one person (CPU) can be doing it, for parallelism, there needs to...
ReadJanuary 19, 2025
Promises in Three Languages
Three ways to handle concurrent API requests that resolve when all are done, but can run concurrently. In other words, if you have three requests and takes 2 seconds, takes 1 second takes 2...
ReadJanuary 18, 2025
The `awk` Command
To determine whether a website is using only IPv6 or if it supports both IPv4 and IPv6 (dual stack), you can do: If only the IPv6 ping is successful, the site might not support IPv4. If...
ReadJanuary 18, 2025
Things to Know About Concurrency
Things to know about Concurrency: Why it's important: Devops involves working with systems that might involve multiple processes, threads, or containers running concurrently. Understanding basic...
ReadJanuary 17, 2025
Bring a Git Subfolder and History to New Repo
Bring a git subfolder and it's history over to start a new repo: https://docs.github.com/en/get-started/using-git/splitting-a-subfolder-out-into-a-new-repository I did this for a repo and it was...
ReadJanuary 12, 2025
Accessing the Docker Linux Virtual Machine
Docker runs on linux natively, but Docker Desktop works on a Mac by creating a virtual machine, installing Linux, and then running on top of that. So, to do some things, like intercepting network...
ReadJanuary 12, 2025
Wireshark
Here's some notes on Wireshark, especially filtering results. You need to set an environment variable in a terminal, AND open the browser from that terminal: Then, you need to tell Wireshark...
ReadJanuary 11, 2025
Why You Can't Group on Column Aliases
When SQLing, I sometimes run across this -- I do
and it won't work and I wonder why. Here's why: The GROUP BY clause is processed before the SELECT. Usually, the order...
January 5, 2025
SQL Window Functions (`OVER`)
So, I found this confusing at first: OVER is how you define a window, and you can use a list of functions, window-specific and aggregate, to populate the...
January 3, 2025
SQL Deadlocks and How They Happen
We had quite a few deadlock issues with some old code at a job I had a few years ago. I feel that occasional deadlocks aren't catastrophic, though a pain, especially if you don't have retry logic in...
Read