New Release: CrateDB 6.4
CrateDB 6.4 comes with enhanced performance, PostgreSQL compatibility, and new aggregation functions, including the largest triangle three buckets for downsampling data.
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.
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.
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.
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.
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.
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.
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.