Recursively expanding JSON fields in postgres
Postgres has some powerful JSON abilities, but there are still limits. This approach allows for exploding a JSONB column out so that each key and value is its own row.
Recent things
Moving files up one folder level in GCP buckets
Due to a strange behaviour in gcloud storage move commands, it can be hard to move files up one level from a subfolder to its parent folder.
Using `eza` to find large files in a directory
Eza has some handy options that make it easier to find large files in a dir.
eza -lT --total-size --sort=size
The characters that python's `isalpha` accepts
The amount of characters accepted by .isalpha() is more than you might expect
Debugging pip's backtracking output
Use PIP_RESOLVER_DEBUG=1 to get actually useful output when pip backtracking fails.
griddle
griddle is a weird little word game where you try and find the least or most common word in a grid of letters.
A million digits
A tool to visualise the first 1,000,000 decimal places of some of the most popular irrational numbers.
Covid vaccinations if each state was a horse
A more lighthearted way to view the 2021 vaccination race between the Australian states