Webinar: Building a Real-Time Platform for Millions of Smart Meter Events

Register Now
Skip to content
Resources

Blog

Time Series Forecasting with SQL

Time Series Forecasting with SQL: DATE_BIN, Window Functions, and Rolling Aggregations

Transform time series data processing by leveraging SQL for feature engineering, eliminating latency and enhancing real-time analysis with effective aggregation techniques.

Read more

Why Industrial Teams Are Moving from Flux and InfluxQL to Standard SQL

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.

Read more

Add sensor types without pipeline downtime

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.

Read more

Data sovereignty for DACH manufacturers

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.

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

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

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

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

The New Industrial Data Stack: Managing Billions of IoT Events in Real Time

The New Industrial Data Stack: Managing Billions of IoT Events in Real Time

Managing billions of IoT events requires a new data architecture. Discover how CrateDB enables real-time analytics for industrial systems.

Read more