Github Actions Step Summary
Do you find yourself wasting time trawling through logs and downloading CI artefacts to find common types of errors? Use GitHub Actions Step Summaries to accellerate your workflow.
Software Development
Where Did That Sqlalchemy SQL Originate?
ORMs such as SQLAlchemy are very useful, but can easily generate very inefficient unrecognisable code. Here’s an easy way to log where the query originates in your code.
Bloom Filter Lightning Talk
A Lightning talk I gave to Dunedin Code Craft in November 2024
Profiling PostGIS with PLProfiler
PLProfiler is a great tool for profiling PL/PGSQL functions, but you need an extra trick for PostGIS native functions.