Reading up on ClickHouse

The article examines why developers often avoid native web platform features, citing historical gaps, familiarity, documentation, enjoyment of building, and AI's influence on code choices.

Developers often avoid native web platform features due to historical gaps, familiarity with libraries, better documentation, and personal enjoyment of building things themselves.

ClickHouse Managed Postgres enables strict memory overcommit so that out‑of‑memory conditions fail a single query instead of triggering an instance‑wide OOM restart, with no measurable throughput loss.

Joel Spolsky's original twelve‑question Joel Test remains valid, but nine additional agent‑focused questions form the Shelley Test for modern software teams.

Neko Master is a modern dashboard for real-time network traffic visualization and analysis, featuring multi-gateway monitoring, Docker-based deployment, and agent-assisted data collection from gateways like Clash and Surge.

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.

PostHog used a Karpathy-style AI agent to find a 3-year-old ClickHouse bug where `toTimeZone()` disabled primary key usage, and the fix cut query time by 37%

Cursor is building local indexes for regular expression search to reduce agent wait times from 15-second ripgrep runs in large monorepos.

Mintlify used ClickHouse to analyze negative assistant feedback, identified search as the main weakness, and shipped UI improvements like conversation history and mobile chat.

ClickHouse provides a 28.74-million Hacker News posting dataset with vector embeddings, enabling large-scale vector search application development and testing.