DRYCODEWORKS

Notes from production

Client case studies and explicitly illustrative worked examples. Case studies describe permitted project outcomes; worked examples explain a technique without claiming a client result.

Case study

A Secure Remote MCP Server for AI Agent Database Access

Per-laptop database logins for an AI agent don’t scale. How I replaced them with one hosted MCP server in production, with permissions outside the model.
Oct 21, 2026 · 4 min
Case study

Training and Evaluation Infrastructure for a Vision Model

An LLM labeling service on Gemini and Claude, versioned training data, shadow serving and a promotion gate: the infrastructure behind a production vision model.
Oct 16, 2026 · 6 min
Case study

IoT Device Identity That Survives Hardware Swaps

Keep a location’s history intact when hardware changes: logical identity, physical units and a safe migration order.
Sep 17, 2026 · 4 min
Worked example

Worked example: a resumable Postgres-to-ClickHouse backfill

A worked example of resumable extraction, checkpointed loading and a checked table swap between Postgres and ClickHouse.
Aug 26, 2026 · 4 min
Worked example

Worked example: ClickHouse insert batching and retry identity

An illustrative event pipeline explains how insert shape affects MergeTree parts and why batching must preserve the unit of retry.
Jul 8, 2026 · 6 min
Case study

ClickHouse Materialized View Memory: ASOF JOIN to Dictionary

A dictionary cut per-insert materialized view memory by 95% in nonprod. Resident memory stayed flat. Why those metrics answer different questions.
May 27, 2026 · 5 min
Case study

Migrating 1.3 Billion IoT Rows to ClickHouse Cloud

How I migrated 1.3 billion IoT rows from SQL Server to ClickHouse Cloud and brought dashboard queries from 45 seconds to under 2 seconds.
Dec 8, 2025 · 16 min
Case study

From 12 Seconds to 150 ms on Lambda and SQL Server

How I led a three-person team to improve an IoT platform’s performance and reliability without leaving SQL Server.
Nov 15, 2024 · 5 min
ClickHouse, AI and AWS Articles | DRYCodeWorks