Featured Work

A few open-source projects and tools I've built or maintained over the years.

Skillful

Local-first platform for managing reusable AI workflows and organisational knowledge.

react-cookie-consent

React cookie consent library installed over 20 million times

Latest Articles
software-development

ORM, query builder, or SQL: choosing the right abstraction level

ORMs are lovely, they can help you speed up a lot, but they shouldn't pretend SQL doesn't exist and I'll explain why.

Read (12 min read)
Development

Keeping massive loads of hot data manageable with PostgreSQL partitioning

Using PostgreSQL's native partitioning to keep high-volume recent data small while cheaply moving older data into an archive.

Read (11 min read)
Development

Stop seeding the whole system to test one query

When you want to know whether a GET endpoint stays fast with 100k orders, do not drag the whole system into the test. Seed the right data, test through the app, and let telemetry guide the next step.

Read (14 min read)
Development

Timezones from coordinates (lat/long): enriching ingestion with PostGIS

A datetime with an offset isn't a timezone. Here's how we use PostGIS and the Timezone Boundary Builder dataset to turn a driver's GPS coordinates into the IANA zone their planner actually needs to see.

Read (10 min read)
Development

Skillful, reusable AI workflows from files you own

What Skillful is, why I built it, and how I use it to manage reusable AI workflows locally.

Read (5 min read)