#
SQL Programming Tutorials & Engineering Articles
957 SQL tutorials, guides, and engineering insights from ClickHouse, Cloudflare, NVIDIA, and more
Companies Using This
SQL Articles & Tutorials
Filter:
Pinterest Engineering
14 min read
--
Yang Yang
13 min read
--
Connect ClickHouse to Amazon S3 Tables to query Iceberg data in place, transform retail analytics, and write reusable results back for dashboards and AI agents.
12 min read
Includes Code
--
To start, here’s the status quo: every Fly Machine gets a private IPv6 address, and every other Machine in your organization can reach it. We call that network 6PN. It’s what my-db.internal points at, and it’s how your app server talks to your databa
Daniel Botha, Peter Cai
12 min read
Includes Code
--
Pinterest Engineering
12 min read
--
Introducing ClickHouse Observability: fully managed observability with the speed and scale of ClickHouse. Just send telemetry; we'll handle the rest. Plus, build the observability experience you've always wanted with a simple prompt in Observability Apps.
9 min read
--
A2UI 1.0 is an open protocol for generative UI that enables AI agents to render interactive, native screens across web, mobile, and desktop applications. Developers can leverage open-source renderer SDKs—including React, Angular, Lit, Flutter, SwiftUI, and Jetpack Compose—alongside agent SDKs for Python, TypeScript, and Dart. The release introduces bidirectional function calls, swappable inference formats, and secure data binding to help teams seamlessly integrate generative UI into their product stacks.
Hitarth Trivedi, Jay Narale, Jianjian Xie, Aerial view of a busy multi-level highway interchange with cars and bright streetlights at night., Yunfei Chen, Sanah Imani
15 min read
--
ClickHouse 26.10 introduces function composition, more flexible joins, faster GROUP BY queries, disk spilling for IN subqueries, an experimental columns cache, and Freeform and SQLite formats.
26 min read
Includes Code
--
Hidehiko ASAHI shares a month of WalShadow private-preview testing, comparing replication latency with ClickPipes and checking data correctness, schema changes, and recovery.
17 min read
Includes Code
--
Xinli Shang, Sivabalan Narayanan, Dharshan Tharumia, Sagar Sumit, Meenal Binwade, Vamshi Pasunuru, Kanan Patel, Suprit Acharya, Kumudini Kakwani, Arnav Balyan, Nimesh Khandelwal
12 min read
--
The September and October ClickStack releases bring ad hoc dashboard filters, PromQL for every chart type, ClickStack query tracing, a Trace logs tab, alerts from the chart explorer, and a long list of search page and collector improvements.
OpenRouter uses ClickHouse Cloud as the single store behind customer analytics, public model rankings, internal AI agents, and routing across 500+ models, as monthly requests grew 33x to 19.7 billion.
Meet GroeneAI, ClickHouse’s autonomous engineering agent that contributed more than 3,000 merged pull requests in under seven months.
21 min read
Includes Code
--
Explore how ClickHouse Cloud turns fresh data into fast answers with efficient preparation, parallelized queries, and elastic scaling.
26 min read
Includes Code
--
ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.
19 min read
Includes Code
--
Jev ranks warehouse tables and labels agent failures in under a second, but adding retrieval hints leaves accuracy flat across 20 models on the Agentic Analytics Benchmark.
Netflix Technology Blog
18 min read
Includes Code
--
Netflix Technology Blog
11 min read
Includes Code
--
NVIDIA Vera tops the ClickBench hardware leaderboard, and three micro-benchmarks for filters, aggregation and joins show ClickHouse scaling almost linearly across its 176 cores.
12 min read
Includes Code
--
Connect Cursor to Langfuse to trace every agent turn, pinpoint expensive model and tool calls, and use evaluations to confirm a fix actually helps, with ClickHouse powering the analytics underneath.
6 min read
Includes Code
--
Learn how Project Chrysalis combines Google Cloud's Gemini Enterprise Agent Platform, Agent Development Kit (ADK), BigQuery, and a four-gate defense-in-depth security stack (Model Armor, Cloud KMS, Binary Authorization, and OPA) to build governed, self-evolving AI agents that remediate live production outages in 1.8 seconds.
Anant Nawalgaria
10 min read
--
We added GPT-6 Astra, Luna and Sol, Claude Opus 5.5 and Claude Sonnet 5.5 to the Agentic Analytics Benchmark: all five land mid-board within a point of each other, and Sonnet 5.5 brings the biggest change in turns, cost and truncated runs.
AWSClaudeFortranGeminiGPTJavaScriptJSONMachine LearningNode.jsREST APIRustSQLSwiftTypeScriptWebAssembly
23 min read
Includes Code
--
Our first scanner read config files and missed what was running. We rebuilt it with the cloud inventory, a careful probe, and honest results.
Simar Singh
9 min read
Includes Code
--
Offload settled Postgres data to ClickHouse to reduce storage and query costs while keeping active transactions in Postgres.
8 min read
--
ClickHouse Cloud delivered 1,996× better performance per dollar than Redshift Serverless in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
24 min read
--
Ridgeline rebuilt its performance analytics on ClickHouse Cloud, querying decades of Iceberg history alongside recent data so it can serve investment managers 10x larger than before and more than double the customers live on its platform.
10 min read
--
A customer saw an extra ~32 ms on simple SELECT queries after idle periods. We traced it to unbatched Native protocol metadata packets overflowing a reset TCP congestion window, reproduced it with network namespaces, and fixed it by batching them.
12 min read
Includes Code
--
At Open House NYC, we showed how ClickHouse Managed Postgres and ClickHouse work as one stack, with a live WalShadow demo replicating Postgres into ClickHouse in under a second, plus the same-week Google Cloud and chdb extension launches.
7 min read
Includes Code
--
Our new repo star history API now provides trends without returning individual identities or requiring unbounded database work. These are the engineering tradeoffs we made.
Enterprise applications have become increasingly demanding. Agentic AI has compounded the need for vast amounts of enterprise data with frequent…
Elizabeth Goodman
7 min read
Includes Code
--
ClickHouse Cloud delivered 438× better performance per dollar than BigQuery in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
Practical lessons from KGMON’s KDD Cup 2026 system for building reliable data analytics agents with constrained tools, persistent state…
15 min read
Includes Code
--
Highlights from Postgres Summit US 2026 in New York City, where ClickHouse sponsored the community and demonstrated its growing Postgres integrations.
7 min read
--
ClickHouse Cloud delivered 752× better performance per dollar than Databricks in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
23 min read
--
Pinterest Engineering
11 min read
Includes Code
--
Executable UDFs are now generally available on ClickHouse Cloud across AWS, GCP, and Azure, with native runtimes, network access, observability, and API and Terraform support.