I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code
PostHog's SQL parser was rewritten using multiple long-running Claude Code sessions in parallel, resulting in a 70x speed increase. The new parser consists of 16,000 lines of code, 5,000 lines of tooling, and additional test code, maintaining equivalence to the previous parser for all realistic queries.
posthog.com
9 min
6/24/2026
I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code
PostHog's SQL parser was rewritten using multiple long-running Claude Code sessions in parallel, resulting in a 70x speed increase. The new parser consists of 16,000 lines of code, 5,000 lines of tooling, and additional test code, maintaining equivalence to the previous parser for all realistic queries.
posthog.com
9 min
6/24/2026
I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code
PostHog's SQL parser was rewritten using multiple long-running Claude Code sessions in parallel, resulting in a 70x speed increase. The new parser consists of 16,000 lines of code, 5,000 lines of tooling, and additional test code, maintaining equivalence to the previous parser for all realistic queries.
posthog.com
9 min
6/24/2026
No more articles to load