Selected projects

CDC Crash Test mark showing data flow reaching a stop

CDC Crash Test

A reproducible lab for a quiet PostgreSQL CDC failure that filled a disk while Debezium reported healthy.

Paired disk-fill experiments and isolated heartbeat trials show why a published-table heartbeat advances the replication slot when a timer alone does not. The failure and fix reproduced in two runs each.

  • Go
  • PostgreSQL 17
  • Debezium Server
  • Docker

EvidencePaired disk-fill runs, repeated heartbeat trials, CSV measurements, and design decisions

Standard Schools

Standard Schools

Academic operations software for two campuses and more than 2,000 students and staff.

A production rewrite that preserved populated data, kept rollback possible, and separated permanent student identity from academic-session enrolment.

  • Next.js
  • PostgreSQL
  • Prisma
  • Tenant isolation

EvidenceMigration, authorization, and production workflows

iballpassyou

iballpassyou

Casual football stats, clear leaderboards, and proper receipts for the group chat.

Pick who showed up, log the goals and assists, then send one receipt the whole group understands. No player accounts and no league-admin ceremony.

  • Next.js
  • Supabase
  • Goal events
  • Group-first UX

EvidenceLive product, public groups, and shareable receipts

theSwiftLine logo with people moving forward along an arrow

theSwiftLine

A virtual queue platform with a calmer interface for organizers and attendees.

The redesign pairs a focused queue workspace with a staged platform migration: a React PWA on Vercel, a Next.js API, durable PostgreSQL state, and individually revocable sessions for anonymous attendees.

  • React
  • Next.js
  • PostgreSQL
  • PWA

EvidenceLive product, public source, migration notes, and contract tests

strictly mark

strictly

A local-first inspector for copied configuration, credentials, and connection strings.

It catches invisible Unicode, malformed structure, suspicious secret characters, and provider-specific mistakes without sending the input anywhere.

  • TypeScript
  • React
  • OCR
  • Privacy by design

EvidenceZero-runtime-dependency library, privacy tests, and local OCR

Shipment route mark with two waypoints and an arrow

DSV Tracking MCP Server

An open challenge that turned live DSV shipment data into dependable tools for AI agents.

The server gives MCP clients a small, typed tool surface over DSV tracking while handling an awkward upstream: browser-based bot protection, ambiguous reference formats, incomplete fields, and operational data that still needs a stable contract.

  • Go
  • MCP
  • Chrome DevTools Protocol
  • Resilient caching

EvidencePublic source, fixtures, ADRs, and live verification