A blog by Andrew Greig

How I wrangled millions of raw vessel position reports into a structured H3 grid — and what that grid makes possible.

I assumed fetching favicons reliably would take 10 minutes but it turned into one of those deceptively simple problems that somehow eats an afternoon.

Code is getting cheap.

If predicting the next word can lead to poetry, problem-solving, and profound insights, then perhaps we're witnessing not the limits of artificial intelligence, but the surprising foundations of intelligence itself.

Many applications reaching for NoSQL databases are solving problems they don't actually have, while creating new ones they definitely don't need—here's why PostgreSQL should be your default choice.

Reducing GTFS ingestion times from 15 minutes to under 10 seconds using PostgreSQL’s COPY FROM

How to set up and configure an Express.js server with Typescript

If you are using the StructuredText block from DatoCMS it can be a bit confusing at first to figure out how to display Code blocks using your own custom component.

When setting up this blog I found myself going in circles a bit trying to get code snippets and syntax highlighting to work nicely without too much configuration.