Resources
Content Library
White Papers
E-Book
Real-Time Monitoring: Selecting the right database
In this e-book, we will explore the key benefits of real-time monitoring, the critical infrastructure components required to implement it effectively, and why CrateDB is the database of choice for real-time monitoring projects.
White Paper
How to get the most out of your Time Series Data
In this whitepaper, we will explore how you can get the most out of your time series data showing you some real-life example.
White Paper
Industrial IoT in 2023 and beyond
In this whitepaper, we will explore three real-life use cases demonstrating the power of IoT technology based on CrateDB.
White Paper
TGW Logistics Redefines Warehouse Intelligence Using CrateDB
TGW simplifies aggregating massive volumes of diverse data with CrateDB, gaining valuable insights to improve customer experience and competitive advantage
White Paper
6 Things Enterprises Need to Consider When Choosing a Database
To help you make the right decision, here’s six things to consider when choosing a database for your next data project.
White Paper
Building an Organizational Culture for a Data-Driven World
This white paper gives recommendations that empower companies to harness the full power of data.
White Paper
How to shape the culture of a data-driven organization
Ride the new wave of the data-driven organization and learn best practices from a global survey of 434 participants in this study by independent analyst firm BARC.
White Paper
Transforming Data into Action
Learn how ALPLA makes data-driven decisions; monitors operations remotely in real-time and how their efficiency improved, and costs are reduced.
White Paper
Discover CrateDB Edge
With CrateDB Edge, customers can deploy a CrateDB cluster on their own infrastructure (on their own premises and/or their own cloud infrastructure) and access it through the CrateDB Cloud web UI
White Paper
Common misconceptions about Industry 4.0 that manufacturers still believe
While IIoT adoption does require a new approach to managing and analyzing data collected in real-time, this isn’t as difficult as many manufacturers believe.
White Paper
Data and Industrial IoT
In order for IIoT projects to succeed, it is crucial to use technologies that have been specifically optimized for this use case. The IIoT implies considerable complexities and particularities in terms of data, and it is unlikely that a database not specialized in IIoT will provide all the necessary requirements.
White Paper
Building IoT applications with open-source tools
Learn how to build IoT applications using an open-source stack: Apache Kafka, Apache Flink and CrateDB.
White Paper
Time-series data in manufacturing
Interested in industrial time-series? This white paper answers all your questions, diving deep into the topic.
White Paper
The cost of running MongoDB, TimescaleDB and CrateDB for industrial IoT
When evaluating the database costs for industrial IoT projects, there's much to consider. Find out how much the monthly price can vary if different databases are used.
White Paper
CrateDB: Technical Overview
A detailed description of CrateDB's architecture. Find out all about how CrateDB is built!
White Paper
How to turn the IIoT into reality
Many IIoT projects fail... But for some manufacturers, Industry 4.0 is already a reality. What is the key to making it work? Read about it in this white paper.
Content Kit
From MongoDB to CrateDB: Migration Starter Kit
Using MongoDB for large-scale IoT projects is like using a Swiss Army Knife to change a flat tire: not a good fit. These resources will help you understand why this is the case.
White Paper
From MySQL to CrateDB: migration guide
A guide presenting how to move your data from MySQL to CrateDB in just a few steps.
Webinars
Webinar
How to replicate data from other databases to CrateDB with Debezium and Kafka
This demo offers a step-by-step guide on leveraging Debezium and Kafka to replicate data from different databases into CrateDB.
Webinar
CrateDB Workshop
CrateDB Workshop is a hands-on learning experience that introduces the fundamental concepts of CrateDB, a distributed SQL database. This workshop is designed for everyone interested in learning about CrateDB features and how it can be used to store, query and analyze large amounts of data.
Webinar
Mastering Monitoring: A Step-by-Step Guide to Using Prometheus and Grafana with CrateDB Cloud
In this interactive live demo, learn, step-by-step, how to use Prometheus and Grafana with CrateDB Cloud.
Webinar
Learn simple No-Code Data Import and Visualization with CrateDB Cloud
In this live demo, our speakers show how easy it is to import data to CrateDB Cloud, connect to a third-party tool and visualize the data for whatever purpose.
Webinar
Real-time Monitoring
To develop a real-time monitoring solution, O-CELL needed a scalable and fault tolerant database with a flexible data schema storage upgrades and ease of use for deploying additional resources. Being their database since an early stage, CrateDB has adapted to O-CELL business needs, offering scalability, reliability and speed, essential for real-time monitoring.
Webinar
Time-series data: From raw data to fast analysis in only three steps
Time-series data and analysis can help businesses understand patterns, trends, and causes over time. This is crucial for business success. In this webinar, Crate.io’s Solution Engineering team will guide you through the implementation steps of a time-series use case - from table layout to querying.
Webinar
How SPGo! builds apps for monitoring and predictive maintenance
SPGo! By PETROMIN, has developed a system that allows monitoring mining material conveyor belts with more than 40,000 sensors in real-time and 760 million records per day.
Webinar
How Bitmovin improves the streaming experience with real-time analytics
In this joint webinar with Bitmovin our speakers will share Bitmovin’s experience, challenges, and why they chose CrateDB as the best solution for their business.
Webinar
German webinar: Fixing data silos in a high-speed logistics environment
In this joint German webinar with TGW Logistics, Alexander Mann explains why they chose CrateDB after trying multiple database systems.
Webinar
Fixing data silos in a high-speed logistics environment
After trying multiple database systems, TGW Logistics moved to CrateDB for its ability to aggregate different data formats and ability to query this information without much hassle.
Webinar
How to leverage CrateDB 4.8 to its full potential
In this webinar, we had a hands-on look at how to leverage the CrateDB 4.8 enhancements when importing data and using Logical Replication to move data between CrateDB clusters to make it available where it is needed.
Webinar
Real-Time Energy Grid Control Based on Big Data
Learn how Gantner relied on CrateDB to analyze the large amount of data generated by the project in real-time and to improve the processes through machine learning.
Webinar
Introduction to Time-Series Visualization in CrateDB and Apache Superset
In this webinar, we will discuss how to use different visualization options in Superset coupled with a SQL interface to derive interesting insights and findings from the time-series dataset.
Webinar
Real time production monitoring in CPG industry
In this joint German webinar with Microsoft, we share the use case of a leading CPG manufacturer and how they reduced their costs with CrateDB and Azure.
Webinar
How real-time IoT data can optimize the supply chain with the Thomas Concrete Group
First-hand insights from Thomas Concrete Group about the advantages of working with CrateDB for different use cases with real-time IoT data.
Webinar
How to improve supply chain management with loT data
Learn why it’s important to be an early adopter of industrial loT practices and how projects can successfully be monitored, measured and optimized using the right database.
Webinar
Why does the industrial IoT need its own database?
The IIoT can cause a new manufacturing revolution... But in order to succeed, it requires the right tools.
Webinar
The design of a time-series database
Best practices for working with time-series data fast, with horizontal scalability, and with SQL.
Videos
Tutorial
CrateDB Workshop Module 1: Introduction to CrateDB and its Architecture
This is the first module where you learn more about what CrateDB is, and what key functionalities this distributed SQL database for real-time analytics offers.
Tutorial
CrateDB Workshop Module 2: Installing and configuring CrateDB
This is the second module where you learn more about installing and configuring CrateDB. Niklas Schmidtmer, Lead Solution Engineer at CrateDB, is guiding you through the installation and configuration of CrateDB, the distributed SQL database for real-time analytics.
Tutorial
CrateDB Workshop Module 3: Inserting and Querying Data
This is the third module where Hernán Lionel Cianfagna, Senior Solutions Engineer at CrateDB, dives into five topics ranging from creating and managing tables in CrateDB to advanced data analysis.
Tutorial
CrateDB Workshop Module 4: Modeling Data in CrateDB
In module 4 Karyn Azevedo, Solution Engineer at CrateDB, shows the data types you can use in CrateDB, gives an overview of indexing, and explains sharding and partitioning. You will also walk away with schema best practices for efficient query execution.
Dev Talk
When ms matter: Maximizing query performance in CrateDB
Achieving optimal execution plans in distributed databases is a challenging task. This talk is focusing on CrateDB: a distributed SQL database, and key strategies for optimizing its query performance.
Use Case
How ABB Ability™ Genix applies AI and analytics to unlock the value of industrial data with CrateDB
In this talk, Marko Sommarberg, Lead Digital Strategy and Business Development at ABB, and Christian Lutz, Co-Founder at CrateDB explain how ABB Ability™ Genix applies AI and analytics to unlock the value of industrial data using CrateDB.
Tutorial
From streaming to insights
A practical guide to building a real-time analytics pipeline with CrateDB and Apache Kafka
Tutorial
Unleashing the Power of Nested Data
Ingesting and querying JSON documents with SQL in CrateDB
Dev Talk
CrateDB Community Day #2
This is the full recording of the second CrateDB Community Day. An event where developers from all over the world connect, share knowledge in short (but fun) talks.
Dev Talk
CrateDB: Distributed SQL database built on top of Lucene
Marija Selakovic and Marios Trivyzas explain CrateDB in detail as part of the Carnegie Mellon University database seminar series 2022.
Tutorial
How to update stock market data automatically with CrateDB and Airflow
In this video, we show you how to update stock market data automatically with CrateDB and Airflow.
Panel Discussion
International Machinery Forum 2022
Georg Traar, Head of Customer Engineering at Crate.io, participated in the panel discussion "Data & Connectivity: how safe is industrial data?"
Dev Talk
Not all Time-Series are Equal – Challenges of Storing and Analyzing Industrial Data
In this talk, we discuss how different data properties affect solutions for data storage, data retention, and data integration.
Dev Talk
Make use of CrateDB's performance potential
Discover how to monitor your cluster to avoid unpleasant surprises, as Marios shares his best practices to keep your cluster healthy at all times!
Tutorial
Introduction to CrateDB Cloud
Romanas demonstrates how to start and scale the new cluster, how to implement logical replication, run data ingestion, and understand the real costs behind CrateDB Cloud.
Video
Introduction to Using Apache Airflow with CrateDB
Learn how to get started using Apache Airflow and CrateDB in this introductory talk by Tamara Fingerlin, Developer Advocate at Astronomer.
Video
How Bitmovin uses CrateDB to monitor the biggest live video events
In this talk, Daniel explains how Bitmovin uses CrateDB to monitor the most significant live video events and especially which features they are using to address their monitoring and scalability challenges.
Video
Analyzing and Visualizing Twitter Conversations
In this talk, Candelario A. Gutierrez from the University of Alberta talks about how we leverage CrateDB into their platform for analyzing social-platform data.
Video
Our Journey with CrateDB
Christian Lutz, founder of Crate.io, is talking about our journey with CrateDB.
Tutorial
Fundamentals: Getting Started with CrateDB
In our Getting Started with CrateDB tutorial we will show you how to run CrateDB on-premises and how to easily interact with it
Tutorial
CrateDB Cloud and Metabase for visualization
Learn how to use Metabase together with CrateDB Cloud
Video
Dynamic workflow orchestration with Apache Airflow and CrateDB
This talk will illustrate how easy it is to automate orchestration workflows with Apache Airflow and CrateDB.
Tutorial
Fundamentals: User Defined Functions
In this video, we explain how to build your own User-Defined Function step-by-step.
Tutorial
Fundamentals: Getting Started with CrateDB Objects
In this video, you will learn the basics of CrateDB Objects.
Tutorial
Fundamentals: Importing and Exporting Data in CrateDB
This tutorial presents the basics of COPY FROM and COPY TO in CrateDB.
Tutorial
Prometheus with CrateDB for long-term metrics storage
This video explains why you would use CrateDB for metric storage and shows you how to start Prometheus, CrateDB, and CrateDB Prometheus Adapter with docker-compose.
Interview
Scaling a high-speed production environment with CrateDB
In this interview, Arno Breuss, CIO of Rauch Fruchtsäfte, talks about how Rauch is filling 33 cans per second and how that adds up to 400 data records per second which are being processed, stored, and analyzed.
Interview
Distributed data acquisition at scale with CrateDB
In this interview, Jürgen Sutterlüti, VP of Gantner Instruments, explains how big the data sets of their customers are and why they need to be accessible in real-time while also being stored for decades.
Dev Talk
CrateDB: A Database or a Search Engine? Both!
Marija Selakovic, Developer Advocate at Crate.io, held a talk at WeAreDevelopers World Congress 2022 in Berlin with the title "CrateDB: A Database or a Search Engine? Both!"
Interview
Redefining warehouse intelligence with CrateDB
Alexander Mann, Digital Corre, of TGW Logistics, talks in this interview about advanced analytics for automated warehouses TGW is operating across the globe for customers like Amazon, Coop, and Zalando.
Video
Data-Driven applications in Intralogistics
The key to the successful operation of warehouses lies in having a holistic view on the entire system based on data from various components. This talk from Alexander Mann, Digital Core TGW Logistics, is about how this data can be retrieved, transformed, and stored in a central place and how to link it with the static site topology so that useful information can be provided.
Video
Data & Construction – Why? What? How?
This talk shows the data utilization efforts in the Rhomberg group: how they try to make their company more data-driven and build intelligent systems to support the core business.
Video
Why so many Industrial Companies Fail to Innovate Radically
In over 60 personal interviews covering more than 20 large industrial companies in Switzerland, Austria and Germany, Zühlke took a deep dive into these questions and found a surprisingly consistent picture of blockers and success factors. Andreas Pfleger, Business Development Manager at Zühlke, presents the results.
Video
Data Insights from Nutrition to Industrial Automation
In this talk, Simon Mayer, Professor of University of St. Gallen, gives an overview of two current research projects that are being conducted at the Institute of Computer Science of the University of St. Gallen.
Video
Finding Your Way in the Cloudy Database Jungle
For data-intensive applications, the database and cloud (or on-prem) resources are the critical components - and performance and cost are the key SLAs. In this talk Daniel Seybold, CTO benchANT, shares his experience and shows how this process can be simplified and made more efficient through cloud database benchmarking.
Video
Demand Prediction for Retail and Industry
In this talk, Franziskos, CEO 7lytix, shows various examples of where demand forecasting and planning are important in industries such as retail and supply chain, how to do it properly and how the value of machine learning shows when it comes to predictive accuracy.
Video
Less blind faith, more credible trust in data
Across almost all industries, the growing number of IoT devices, increasing interoperability between systems and data transfer across companies continuously attracts more and more attackers to not only steal or encrypt data but also actively tamper it. In this talk Thomas Plank, CEO Tributech, talks about data notarization to establish credible trust when it comes to data.
Video
Decision Making with EDGE and AI
Christian Lutz, Founder and President of Crate.io, talks about decision-making at the EDGE and with AI and how CrateDB is enabling customers to turn data into business value.
Video
Data Insights Day 2022
Crate.io brought together regional thought leaders, customers, and partners to equip the attendees in the Dornbirn offices with the technical know-how, practical advice, and expert insights on connecting data insights to business outcomes.
Dev Talk
FOSDEM '22: Distributed Join Algorithms in CrateDB
Marija Selakovic, Marija Selakovic, Developer Advocate at Crate.io, explains at FOSDEM'22 how we made distributed Joins 23 thousand times faster.
Video
Decision Making with EDGE & AI
Christian Lutz, Founder and President of Crate.io, talks in German about decision-making at the EDGE and with AI and how CrateDB is enabling customers to turn data into business value.
Podcast
The Benefits of Time-Series Databases and Opening Up Businesses Digitally
The challenges of digital disruption and transformation form the basis of this podcast. Scott Taylor, Principal Consultant at MetaMeta Consulting, speaks with Christian Lutz, Founder, President at Crate.io, and Bernhard Zimmermann, Director Business Development and Partner at Zühlke.
Video
Powering Smart Buildings with data-driven Decisions
Eva Schönleitner, CEO Crate.io, and Bas Boorsma, Chief Digital Officer City of Rotterdam, talk at the Sensors & IoT Conf 2021 about the challenges with data in smart buildings and what are the technologies necessary to fuel opportunities. See how CrateDB streamlines information and tailors data access to deliver real-time information when it's needed.
Video
The Edge is Here: How Cloud and On-Premises Combine for Better Data Storage
Crate.io CEO Eva Schönleitner presents "The Edge is Here" during the Manufacturing Data Summit Europe 2021 announcing CrateDB Edge
Interview
The Edge eats the world
Eva Schönleitner & Christian Lutz in an hour long conversation in German with Bernard Sonnenschein about the origin and future of CrateDB
Video
How to win with AI and data: Ash Fontana in a conversation with Christian Lutz
Ash Fontana, author of The AI-First Company: How to Compete and Win with Artificial Intelligence, talks to Christian Lutz, Founder and President of Crate.io about how to transform a company into an AI-first company.
Product Presentation
CrateDB Edge product presentation at Hannover Messe 2021
Crate.io CEO Eva Schönleitner and Bernhard Zimmermann, Director Business Development at Zühlke Austria, are talking about edge computing and CrateDB Edge.
Panel Discussion
Tales from the machine room
Crate.io's CEO Eva Schönleitner, President Christian Lutz, and CTO Bernd Dorn are talking about why Crate.io open sources the entire codebase of CrateDB with version 4.5.
Use Case
CrateDB in the Wild with Quantum Leap
Dr. Federico M. Facca talks about using CrateDB in an open-source project "CrateDB in the Wild with Quantum Leap"
Panel Discussion
What it means to align with open source values
During the Open Source Release Event of CrateDB v4.5 we hosted a panel discussion and discussed "What it means to align with open source values"
Webinar
Automating smart factories to monitor machines with n8n and CrateDB
In this webinar we build an automation workflow for industry 4.0 using n8n and CrateDB.
The IOT Show
Turning IIoT data into action with CrateDB
Johannes Moser presents what CrateDB can do, showing it live in a demo
Tutorial
Getting started with CrateDB Cloud on Azure
Luke from the Product Team explains how to deploy CrateDB Cloud in a few quick steps
Interview
A conversation about industry, innovation and CrateDB
Christian Lutz chats with Maggie Miller during the IoT World conference in Santa Clara, California
Interview
Engineers from GolfNow explain why they chose CrateDB
Sheriff Mohamed and Marcus Briggs, engineers at GolfNow, talk about CrateDB and their experience with it
Dev Talk
Using containerized databases in a machine data environment
How can containerized microservices increase productivity in industry 4.0 use-cases? Claus from Crate.io shows real-world examples
Dev Talk
My experience migrating to MongoDB
Why CrateDB made me wish I had a time machine, by Marios Trivyzas