Skip to content
Blog

Articles about SQL

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

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

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

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