Skip to content
Resources

Blog

Predictive maintenance database architecture

Predictive Maintenance Database Architecture: From Sensor Data to Maintenance Trigger in SQL

Learn the three SQL patterns that power predictive maintenance: threshold triggers, trend detection, and cross-asset correlation. See how CrateDB serves as the data layer under ML models for industrial IoT at scale.

Read more

OPC-UA and MQTT into SQL with Telegraf

How to Ingest OPC-UA and MQTT Data into SQL with Telegraf and CrateDB

Learn how to seamlessly ingest OPC-UA and MQTT data into SQL using Telegraf and CrateDB, enabling real-time insights and efficient data management for industrial IoT.

Read more

Cross-Plant Visibility in One SQL Query: Ending the Analytics Silo Problem

Cross-Plant Visibility in One SQL Query: Ending the Analytics Silo Problem

Learn why industrial analytics become siloed per facility, why consolidation layers fail at operational speed, and how manufacturing and logistics teams query all sites in one SQL statement.

Read more

Edge analytics for industrial IoT

Edge Analytics for Industrial IoT

Learn why cloud-only analytics fails at the factory floor and how CrateDB's edge deployment handles OT/IT separation, DACH data sovereignty requirements, and sub-second query latency on live sensor data.

Read more

IoT Analytics at Scale: Architecture Guide for Industrial Data

IoT Analytics at Scale: Architecture Guide for Industrial Data

Build real-time industrial IoT analytics with Telegraf, CrateDB, and Grafana. SQL examples, architecture patterns, and proof from ALPLA, ABB, and TGW. Learn more.

Read more

OEE Analytics on Live Data: How to Move from Nightly Exports to Real-Time Dashboards

OEE Analytics on Live Data: How to Move from Nightly Exports to Real-Time Dashboards

Learn why batch export architectures make OEE dashboards too slow for shift supervisors, and how manufacturing teams cut query times from 3 to 5 minutes to milliseconds with a real-time analytics database

Read more

Migrating from InfluxDB to CrateDB: The Telegraf Output Plugin Swap

Migrating from InfluxDB to CrateDB: The Telegraf Output Plugin Swap

In this post, I am going to show you how to set up Telegraf and have it send metrics data to CrateDB.

Read more

Data historian vs time series database

Data Historian vs. Time Series Database: Which Belongs in Your Industrial Stack

Compare data historians and time series databases on OT connectivity, query language, and analytics depth. Learn why most industrial stacks benefit from both.

Read more

The InfluxDB Cardinality Problem: Why High-Cardinality Industrial Data Breaks It

The InfluxDB Cardinality Problem: Why High-Cardinality Industrial Data Breaks It

Learn why InfluxDB's TSM storage model hits a cardinality wall at industrial scale, and how CrateDB stores 900 sensor types in a single table without a series ceiling.

Read more

New release: CrateDB 6.3

New release: CrateDB 6.3

CrateDB 6.3 enhances compatibility with SQL and PostgreSQL, unifies object store access, and improves resilience, making integration with third-party tools easier.

Read more