Stop all containers docker
To stop every running container in Docker, pass the output of docker ps -q to docker stop.
Today I Learned
Inspired by Simon Willison’s Today I Learned series, here are bitesize posts explaining how to do something.
This is basically a list of public notes, for things I need to do semi-frequently, i.e - not often enough to cram into my memory. Hopefully some of them are useful to you too!
Spell checking in emacs
You can install a spellchecking tool like ispell or aspell and use a package in Emacs to do spell checking, then fix words with a handful of shortcuts.
Setup a yubikey for authenticating in macOS
Change the default PIN and PUK on a YubiKey with the YubiKey Authenticator app, since it defaults to 123456 and you don't want that in case someone finds your key.
Retrieve secret from GCP secret manager
List the secrets in a GCP project and read the latest version of one with gcloud, grepping out just the bit you need.
MX records from command line
To get the mail (MX) records for a domain, you can ask dig for them from the command line.
How to search inside json blob in PostgreSQL
To dig into a JSON blob in Postgres, use the @> containment operator to match objects inside a JSON array.
How to pick a lock
To lock pick a pin tumbler you need two tools: a tensioner and a pick. Then you push the pins up past the shear line so you can turn the key.
How to mirror two folders so they are identical
Using rsync you can mirror one folder to another, deleting anything in the destination that isn't in the source.
How to make a public claim ahead of time
To make a claim now that you only want to reveal later, you can shasum the message, post the hash publicly, then reveal the original later to prove it matches.
How to get results between two dates in SQL
To grab rows between two dates, use BETWEEN in your WHERE clause.
Get fingerprint of SSH key
On github.com your SSH keys show a fingerprint, not the full public key. So if you had multiple keys, how could you figure out which one maps back to the one on GitHub?
Find text inside a folder of files
Search files recursively for a term with line numbers, or pipe find into grep to match on file names.
Find in use ports
How do I tell what ports are in use on my computer?
Export SQL to CSV
Wrap psql in a small shell function and use COPY ... TO STDOUT WITH (FORMAT csv, HEADER true) to export a query straight to a CSV file.
Describe a GCP cloud run job
Running gcloud run jobs describe shows a Cloud Run job's tasks, parallelism, container image, memory and more.
Creating new roles in Postgres
Grant a new Postgres user connect, schema usage and table privileges, then check what they've been granted.