Blog: Notes from production

Selected notes

These are pieces of my working notes, edited for public eyes. They won't reveal the details of what I build, but they might explain why I build at all.

CI · Testing · Postgres

Thirteen minutes of CI

What runs on every change, why the slowest check stays, and why a merge should decide from the results rather than from the wait finishing.

PostgreSQL · Migration · Databases

Containerising JAS: every store on two databases

Progress on moving the Job Adding System to Postgres: every store shadow-writing in production, a clean first day of soak, and what turned up on the way.

PostgreSQL · Performance · Databases

Shadow writes slowed a job by a third

A sync job slowed from 400 to 534 seconds once it wrote to Postgres as well as SQLite. How I measured it, where the time went, and the fix that brought it under 380.

PostgreSQL · Migration · Databases

Rehearsing a database read switch

Before reads move from SQLite to Postgres: why identity sequences fall behind under dual writes, the seven-second switch window, and proving the rollback repairs a lost write.

Containers · Docker · Dockerfiles

Docker Best Practice

What I consider best practice for Dockerfiles: small images, sensible layering, and builds that are reproducible and safe to run.