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...

Read

January 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...

Read

January 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...

Read

January 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...

Read

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...

Read

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

December 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...

Read

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...

Read

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...

Read

December 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...

Read