06 / UNDER THE HOOD

Technical

Longer write-ups on how the things I build actually work: data pipelines, MCP servers, agents and the infrastructure around them.

Let Code Shortlist, Let the Model Pick

Rules for matching bank lines and invoices can't learn, so I kept writing new ones. Now code builds a short list, a decision model picks from it, and a Cloudflare Workflow waits for a person when the model isn't sure.

CloudflareWorkflowsWorkers AIOpenAILLMDecision models

Let Cloudflare Do the Login

Our customers ask Claude and ChatGPT about their solar plants. Cloudflare Access and an MCP server portal handle who gets in, so we didn't have to build auth. The cf CLI lets my agent set it up without a browser.

MCPCloudflareAccessAgents

Run, Wait, or Skip

Wawa used to send every saved WhatsApp batch to the task model. Now a single decision call picks run, wait, or skip first, and anything it isn't sure about still runs.

WawaWhatsAppLLMOpenAIWebhooksSQLite

Searching WhatsApp Voice Notes on a CPU

Wawa's Spotlight searches saved messages, images, audio and video with EmbeddingGemma 2 on a local Ollama. No GPU, no transcripts, and the index lives in the workspace database.

WawaOllamaEmbeddingGemmaEmbeddingsSearchFFmpeg

Tauri Wasn't Much Lighter Than Electron

I measured a Tauri and an Electron window for Wawa's desktop app. The window was smaller. The whole app wasn't, until the sidecar moved from Node to Bun.

TauriElectronBunBaileysWhatsAppDesktop

One Record, Many Views: Wawa's Work-Item Model

Wawa used to store every item as a task. Now it keeps what an item is, where it stands and when it matters as separate fields on one record, with waits stored apart.

WawaGTDLLMDomain ModelingSQLite

Write Many, Merge on Read

Our Dagster steps kept fighting over the same Postgres rows. Now they append events to Cloudflare Basin streams, a sink lands them in Iceberg, and the reader decides which version wins.

DagsterCloudflareBasinIcebergDuckDBData Pipelines

One MCP Server for Claude and ChatGPT

We put our solar plant data behind a remote MCP server on Cloudflare, with Auth0 for login. Going stateless saved us. Auth was the hard part.

MCPCloudflareAuth0LLM

One Durable Object Per Site

Users write their own threshold rules. Each site gets one Durable Object that checks them. The database owns the rules, the object owns the checking, and a version number keeps them honest.

CloudflareDurable ObjectsWorkersMonitoring