ClickHouse
4 articles in the last 30 days.
-
pg_clickhouse 0.11.1: Now with pgvector, UPDATE, DELETE pushdown
Version 0.11.1 of pg_clickhouse adds UPDATE, DELETE and TRUNCATE support and pushes pgvector search down to ClickHouse. It also maps pgvector types to ClickHouse Array(Float32) columns.
-
Researcher Demonstrates Database RCE Exploits Affecting PostgreSQL, MySQL and Oracle
Low-privilege database accounts can reach memory-corruption bugs in SQL engine code and run code on the server. Proofs of concept target PostgreSQL, MySQL and ClickHouse, with a separate Oracle chain.
-
Why we're moving our warehouse off DuckDB
PostHog explains why it is re-architecting its warehouse product away from DuckDB and DuckLake after single-node memory limits and catalog write bottlenecks appeared at customer scale.
-
ClickHouse + dbt: Building a GitOps workflow at Twilio
Twilio replaced a Kafka, Spark Streaming and Elasticsearch pipeline with a single ClickHouse system managed by dbt, using materialized views in place of custom Spark code. Schema changes now go through GitOps and dbt lineage.