Debugging pip's backtracking output
Use PIP_RESOLVER_DEBUG=1 to get actually useful output when pip backtracking fails.
Recent things
Using `uv` to exclude dependencies newer than a specified date
A handy feature of uv that allows you to specify a datetime, and uv and won't install dependencies that are newer than that date
Get sizes of tables in postgres
Searching the current folder on a mac by default
A handy productivity improvement
websearch_to_tsquery for Postgres full text search
Full text search in postgres is awesome but constructing queries can be a bit tedious. websearch_to_tsquery makes that super easy.
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