ClickHouse vs OVHcloud

Introducing ClickHouse's new TimeSeries Engine: Your drop-In Prometheus replacement

ClickHouse PromQL support lets you store Prometheus metrics in ClickHouse Cloud, query them using familiar PromQL, and bring metrics together with your logs and traces without rewriting queries in SQL.

High-Performance ETL for Apple Health XML Exports

This technical tutorial describes building a high-concurrency ETL engine to process very large Apple Health XML exports. The author outlines a performance-first architecture: a streaming Rust XML parser (quick-xml) to extract <Record> tags, export data as Apache Arrow record batches via PyO3 for zero-copy consumption in Python/Polars, and bulk-ingest cleaned data into ClickHouse using clickhouse-connect. The post includes code snippets for the Rust parser, Arrow-to-Polars bridge, ClickHouse table schema and bulk insert, and discusses production considerations such as parallelization, schema evolution, malformed XML handling, Grafana visualization, and feeding Arrow buffers into ML frameworks like PyTorch.

• Apple Health exports a single massive XML file containing millions of <Record> tags.
• The pipeline uses a streaming Rust parser (quick-xml) to avoid loading the entire XML into memory.
• Rust code is wrapped with PyO3 to return Apache Arrow tables for zero-copy consumption by Python/Polars.

NeverBlink Adds ClickHouse Support

NeverBlink, an AI-driven database administrator, announced support for ClickHouse, extending its database resilience and optimization platform to ClickHouse clusters. The integration offers continuous health checks, automated root-cause analysis, query analytics, prioritized remediation guidance, and optional unlimited expert consulting via BigData Boutique. NeverBlink already supports Elasticsearch and OpenSearch and is used in production by companies including Akamai, Perforce, and Palo Alto Networks. The article notes ClickHouse has surpassed 4,000 customers and a reported $15 billion valuation. Leadership quotes emphasize reducing downtime, lowering costs, and accelerating database optimization in the AI era.

• NeverBlink announced support for ClickHouse, extending its AI-native database resilience and optimization platform to ClickHouse clusters.
• NeverBlink is described as the world’s first AI database administrator (DBA) and already supports Elasticsearch and OpenSearch.
• ClickHouse has reportedly surpassed 4,000 customers and a reported $15 billion valuation.

Import Leased /24 into OVHcloud via BYOIP

A technical how-to explaining how to import a leased IPv4 /24 block into OVHcloud using BYOIP (Bring Your Own IP) to avoid OVHcloud's per-IP rental fee. The author compares OVHcloud's $2.39/month per IP charge (about $612/month for a /24) with leasing a clean /24 (cited from IPbnb at ~ $79/month) and describes the requirements (supported RIRs, prefix size, clean/unannounced status, WHOIS allocation), the setup steps (publish a route object with OVH's ASN, prove control via a token in the inetnum WHOIS record, order in OVH Control Panel, assign to service to announce), and operational gotchas (region selection, WHOIS/rDNS delegation, withdraw previous announcements, anti-DDoS included). The post highlights that leased blocks can be used with BYOIP if proper authorization and routing/ROA objects are in place.

• OVHcloud charges $2.39 per additional IP per month, which totals about $612/month for a /24 (256 addresses × $2.39).
• BYOIP (Bring Your Own IP) lets OVHcloud announce IP space you control so OVH does not bill per-IP rental for imported space.
• Supported RIRs for OVHcloud BYOIP are ARIN, RIPE, and APNIC; minimum block size is /24 and maximum is /19 (delivered as /24s).