writer://
January 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
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 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 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...
ReadDecember 29, 2024
Kubernetes ConfigMap Values
Extract a Specific Key from a ConfigMap: You can use jq
or yq
to parse JSON or YAML output to get specific values. For example, to get the value of a specific key in a...
December 21, 2024
Command to Find a Command's Shared Libraries
Command to find out what shared libraries an executable needs: ldd /bin/bash
eg
When I created a chroot test, I copied /bin/bash
and then did the ldd, and it was not...
December 21, 2024
Command to Find a Command's Apt Package
Sometimes I type a command in linux and it's not found. I try to install it and it's not found. Often it will say what package you need to install, but when it doesn't it's usually something...
ReadDecember 21, 2024
Python Instance Types
Python's gettype
or instanceof
is isinstance()
.
isinstance()
can be used to check for a variety of object types in Python. Here are some common...