» Tag
clickhouse
9 postsPostgreSQL and the Linux OOM Killer: A Safer Default
How strict Linux memory overcommit (vm.overcommit_memory=2) prevents OOM-killer-driven crashes in PostgreSQL, backed by a direct benchmark comparison.
apitap: Rust-Based ELT Engine Moves 10M Rows in 9.9s
Open-source Rust engine apitap moves 10M database rows in 9.9 seconds via a single function call, benchmarked against dlt and ingestr.
ClickHouse vs Postgres: A 100 Million Row Showdown on a Mac Mini
A Mac Mini M4 benchmark pits ClickHouse against Postgres across 100 million LLM trace rows, comparing ingest speed, disk usage, and query latency.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comAdvanced Partitioning Strategies for Petabyte-Scale Tables
Learn about effective partitioning strategies for petabyte-scale datasets. Best practices for performance and management.
Database Comparison: SQLite, DuckDB, PostgreSQL, and More
Explore features of SQLite, DuckDB, PostgreSQL, MariaDB, ClickHouse, and MongoDB. Essential insights for engineers.
chwire: A New Native-Format JavaScript Client for ClickHouse
chwire is an open-source JS client for ClickHouse that speaks the Native binary format over HTTP and TCP, offering much faster encoding and decoding than JSONEachRow.
pg_stat_ch Streams PostgreSQL Query Telemetry into ClickHouse
pg_stat_ch is an open-source PostgreSQL extension that streams raw per-query telemetry to ClickHouse, offloading analytics from the database engine.
What Matters for Performance: Lessons from a Year of Benchmarks
Benchmarks from ClickHouse reveal critical insights into data processing efficiency and performance.
Helicone Enables Users to Write SQL Directly to a Shared ClickHouse
Helicone has launched HQL, allowing users to write SQL queries on a shared ClickHouse. Security is ensured through row policies.