Tech NotesNo. 018·v.2026.06JA

↳Translated from Japanese — Japan-flavoured topics may appear. Read the original

Tech Notes

Technologies explained, as clearly as I can manage. Notes left for myself, in case I forget.

[ Index ]

18 entries

Every note, newest first. Search or filter by tag.

2026-06-10The Bach Generator That Stopped RepairingGenerate the notes, then fix the rule violations. The more I fixed, the less it was music.#programming

2026-05-30Wiring an Idol Agency for Data-Driven ManagementHow I stood up a self-hosted MCP server as the substrate for running agency decisions through Claude Code — three-tier auth, two-stage data filters, and a JSON pitfall hit in production.#infrastructure#security

2026-05-25Treating Excel as the SpecWhen the spec lies, you make the artifact the spec. A two-week test harness.#testing#programming

2026-05-20Dashboarding an Idol Agency with Metabase and Cloudflare TunnelSquare, TimeTree, Discord — scattered data, one MySQL, zero public IPs.#infrastructure

2026-05-15Mining Words Without a DictionaryI wanted to find unknown words without a dictionary. PMI and Bloom filters were my weapons. They weren't enough.#search#programming

2026-05-10MySQL vs MariaDB Binlog: The Fork That Split the StreamSame magic bytes. Same row events. Completely different GTIDs.#database#infrastructure

2026-05-05Surviving OIDC Back-Channel LogoutWhy "logout" is the hardest button in a microservices architecture.#security#infrastructure

2026-04-30Thread Pool Starvation: From Blocking recv() to Reactor I/OTwo workers, two persistent connections. Nobody left to answer.#infrastructure#programming

2026-04-25Why WASM Lost to js-yamlI tried Rust. I tried C++. js-yaml won both times. A story about where WASM stops being fast.#programming#web

2026-04-20Letting Claude Code Build the ServersI inherited a single-rack on-prem datacenter and now Claude Code does the building. I make decisions and approve diffs. Here's the shape of the scaffolding that made it possible.#infrastructure#ai

2026-04-15Scars in the Source: Lessons from Claude Code's Leaked CommentsWhat 512,000 lines of source code left behind wasn't implementation — it was a record of battles fought.#programming#ai

2026-04-10MySQL 9 Binlog: What's Actually DifferentThe backward-compatible design held up. But a new data type doesn't care about that.#database#infrastructure

2026-04-07Taming Image Exclusion in a Vertical Typesetting EngineI built image exclusion for a vertical typesetting engine. Three coordinate systems showed up.#programming#web

2026-04-02Kickstart on XCP-ng: Five Silent TrapsFive traps I fell into getting Kickstart to work on XCP-ng. All silent.#infrastructure

2026-03-27Wrestling with ANN IndexesFinding the "closest taste" among ten million bottles of wine.#ai#database

2026-03-20Compressing an Inverted IndexHow to fit a million document ID lists into memory.#database#programming

2026-03-15The MySQL BinlogI wrote a binlog parser, and 20 years of design decisions came raining down.#database#infrastructure

2026-03-07Building a Tokenizer from ScratchHow do you grammatically split "tabesaserarenakatta"?#programming