Tag
memFrame is an open-source dataframe API that translates Python DataFrame operations to SQL, enabling computation to stay within databases like DuckDB, PostgreSQL, and ClickHouse, and includes a multiagent architecture for natural language data interaction.
Andy Pavlo, a renowned database professor from Carnegie Mellon, joins ClickHouse to establish and lead ClickHouse Labs, a new research group focused on advancing database technology and integrating innovations into ClickHouse and PostgreSQL.
Analysis of Hacker News titles reveals that '2' is the most popular number, but many counts are inflated by decimal numbers like '2.0'. The author refines the query to filter years and combine decimal numbers.
ClickHouse releases @clickhouse/rowbinary, a Node.js library for reading/writing RowBinary formats that also includes a skill file enabling coding agents to generate query-specific, high-performance parsers that run 1.5–3.4x faster than generic parsers.
Helicone implemented a feature called HQL allowing customers to write raw SQL queries against a shared ClickHouse database. They use ClickHouse row policies and custom settings to enforce multi-tenant isolation, ensuring each organization can only see its own data.
ClickHouse Managed Postgres scales PgBouncer to 4x throughput by running a fleet of processes with SO_REUSEPORT, enabling multi-core utilization and solving cancellation forwarding via peering.
The article argues that ClickHouse has become the dominant database for observability due to its performance handling high-volume, time-ordered logs, solving long-standing log management challenges.
chDB is a complete ClickHouse OLAP engine compiled to WebAssembly, enabling SQL queries directly in the browser via a SQL shell at wasm.chdb.io.
A ray tracer implemented entirely in ClickHouse SQL queries, rendering images to PNG without any external code or UDFs. Demonstrates procedural terrain, CSG geometry, and parallel pixel computation.
ClickHouse Cloud announces WAL-RUS, an open-source Rust rewrite of WAL-G for PostgreSQL backups, focusing on predictable memory usage and WAL-G compatibility.
Silk is a new stackful-fiber library and scheduler for ClickHouse, designed to improve asynchronous I/O performance with NUMA-aware work stealing, io_uring, and zero heap allocation in the hot path. It targets I/O-bound components like distributed cache, object storage, and network I/O.
ClickHouse has released PostgresBench, a public and reproducible benchmark for comparing managed Postgres services, using the standard pgbench tool with TPC-B-like workloads at multiple scale factors.
Maple service map now displays important stats and metrics for various databases including Redis, Postgres, Clickhouse, and MySQL.
PostHog used an AI agent based on Karpathy's autoresearch to find a three-year-old bug in their ClickHouse query engine that prevented proper primary key usage for timestamp filters. Fixing it improved performance by 11% and reduced scanned granules by 62%.
Silk is an open-source cooperative fiber scheduler for Linux with per-CPU scheduler threads, io_uring integration, and topology-aware work-stealing, designed for high concurrency with low overhead.
The author shares a personal breakthrough in understanding columnar stores while building a game engine, relating it to Trizen's ECS and ClickHouseDB.
Maple's service map now automatically shows databases your services are calling, with upcoming integrations for Planetscale, Tinybird, and Clickhouse for more details.