How to Use SQL for ML Feature Engineering on Time-Series Sensor Data
Discover how to leverage SQL for efficient feature engineering on time-series sensor data, enhancing machine learning model accuracy without memory bottlenecks.
Why Industrial Teams Are Moving from Flux and InfluxQL to Standard SQL
Explore the challenges of migrating between InfluxDB query languages and discover the advantages of standard SQL for industrial IoT analytics.
How to Add a New Sensor Type to Your Industrial Database Without Pipeline Downtime
Discover how CrateDB's dynamic columns enable seamless integration of new sensor types in industrial databases without downtime, enhancing operational efficiency.
Data Sovereignty for Manufacturing Analytics: Why Cloud-Only Doesn't Work in DACH
Explore why DACH manufacturers need on-premises analytics databases to comply with strict data sovereignty laws while achieving real-time insights from production data.
Comparing MongoDB, TimescaleDB, InfluxDB, and CrateDB for an IIoT Use-case
In this blog post, we compare how MongoDB, TimescaleDB, InfluxDB, and CrateDB perform for an industrial IoT use-case.
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.
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.
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.
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.
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.