Querying Metrics with OxQL

Oxide and Friends · 2 Oct 2024 · 1h 35m · Episode 26

What this episode covers

Ben Naecker from Oxide explains the development of OxQL, a custom query language for their telemetry system, and the decision to use ClickHouse as the underlying database. The team discusses why standard options like PromQL and OpenTelemetry were rejected due to limitations in handling histograms, typed data, and complex aggregations required for rack-scale debugging. Naecker details the normalized data model, ClickHouse's compression and performance characteristics, and the implementation of the DSL using Rust's PEG crate.

Mentioned

Products
OxQL, Humility Dashboard, Crucible
Tools
ClickHouse, PromQL, OpenTelemetry, InfluxDB, CockroachDB, Victoria Metrics, Ratatouille, PEG, Pest, ANTLR, Data Fusion, Arrow

Other shows on the same ground, closest first.

  • The Robot Report Podcast · 1h 06m

    Unlocking the Power of Time Series Databases for Industrial and Robotic Systems

    Doug Pagnutti, Developer Advocate at Tiger Data, explains how TimescaleDB, a PostgreSQL extension for time series data, helps robotics developers manage high-volume telemetry, spatial, and multimodal data. He details strategies for edge-to-cloud data synchronization, the use of continuous aggregates and compression to handle fleet-scale data, and integrating with industrial tools like Ignition and MQTT. The conversation also covers the emerging need for hybrid search stacks to combine temporal data with vector embeddings for AI-driven maintenance and fleet optimization.

The summary, chapters and topics are generated from the episode’s audio by this directory, not written by Oxide and Friends. The episode itself belongs to its publisher.