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

Register Now
Skip to content
Blog

Articles about SQL

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

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

IoT Analytics - Query Live Device data

IoT Analytics: Turning Real Time Device Data into Actionable Insights

Discover how IoT analytics transforms real-time device data into actionable insights, optimizing operations and enhancing decision-making across industries.

Read more