Recent things
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.
How to pass a list as a param to pandas read_sql_query with sqlalchemy
I'm very used to passing an array of items to a postgres query using libraries for nodejs like pg-promise so was surprised how hard it was to figure out how to do this with python, pandas and sqlalchemy
Get postgres query results as JSON
A super handy snippet to get the results of a query as JSON
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