I wrote a 70x faster SQL parser while barely looking at the code - PostHog

kept by eddie jun 25

The author used AI agents to rewrite PostHog's SQL parser in Rust, achieving a 70x speedup (454x in production) via property-based testing and oracle-based development.

I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code
PostHog's engineer used parallel Claude Code sessions to rewrite their SQL parser, achieving a 70x speedup by fuzzing against the old ANTLR-based parser as an oracle.
also on ANTLR, PostHog, Claude Code, #ai-coding, #software-engineering, #developer-tools
Autoresearch, Claude and Constrained Optimization
An experiment using Claude Code to autonomously optimize a file compression algorithm over 10 iterations, achieving competitive results against standard tools by iterating on an LZSS-based approach.
also on PostHog, #rust, Claude Code, #ai-coding, #software-engineering, #developer-tools
Claude Code made me love meetings again
AI coding tools like Claude Code reduce the need for deep flow states, freeing mental capacity to enjoy spontaneous meetings and interruptions.
also on PostHog, Claude Code, #ai-coding, #software-engineering, #productivity, #developer-tools