2025–present
Lazy pagination at scale
Replaced full-table counts and added filter indexes, eliminating timeouts on a view spanning approximately 26 million records.
The work between the stops
Engineering, teaching and the things on the side. Grouped into initiatives, with a story behind each one.
6 contributions
Reset filtersYears refer to the project or role period. These summaries draw on my CV and published recipes; private PRs and client data are not reproduced.
2025–present
Replaced full-table counts and added filter indexes, eliminating timeouts on a view spanning approximately 26 million records.
2025–present
Safely removed 11 redundant PostgreSQL indexes across two estates, reclaiming approximately 1.43 TB.
2025–present
Blocked approximately 483,000 invalid updates per month across two enterprise clients.
2025–present
Corrected overlapping meter dates, preserved required fields and built bulk repair tooling with dry-run support.
2025–present
Fixed a validation defect responsible for 3.7 million application errors, adding regression tests and diagnostic logging.
2025–present
Implemented and tested SSO for two organisations using OIDC, Okta and django-allauth with email-domain routing.