Cloud Time Series Database Evaluation: GridDB Cloud vs. InfluxDB Cloud vs. MongoDB Atlas. Click here to read now!
GridDB Developer
Download

Back to Resources

Technical Showcase

GridDB University

A complete course on building IoT applications with GridDB. Starting from why traditional databases fall over under time-series workloads, this white paper walks through GridDB's Key-Container data model, the "no JOINs" design philosophy, time-series partitioning and expiry, and SQL-based aggregation and downsampling. It then covers the practical stack: writing and querying data from Java, Python, JDBC, and the Web API; batching with multiPut() and MULTI_GET for performance; real-time ingestion with Kafka Connect; and securing a Flask API with GridDB as the identity store. The final chapters move to GridDB Cloud, with serverless ingestion via Azure IoT Hub, Grafana Cloud dashboards through the Infinity plugin, and automation using the GridDB Cloud CLI.

What's Inside

  1. An Introduction to IoT and Time-Series Data (The IoT Data Deluge, Why Traditional Databases Struggle, Introducing GridDB, Smart Factory Use Case)
  2. Core Concepts: Containers and Data Modeling (The Container, Design for a JOIN-less World, One Container Per Sensor, Schema Example)
  3. Working with Time-Series Data (Partitioning and Expiry, SQL Time-Series Functions, Downsampling with GROUP BY RANGE, Aggregation and Real-Time Analytics, Bulk Operations)
  4. Writing Data to GridDB (Java Client, Batch Inserts with multiPut(), Python, JDBC, Web API)
  5. Querying Data from GridDB (SQL and JDBC, Server-Side Aggregations, Python and Pandas, Apache Arrow, Web API)
  6. Performance Tuning and Optimization Strategies (Network Latency, Optimizing Writes with multi_put(), Optimizing Reads with MULTI_GET and IN Clauses)
  7. Real-Time Streaming with Apache Kafka (Kafka in an IoT Architecture, GridDB Kafka Connect Framework, Sink Connector, Source Connector)
  8. Building a Secure API with Flask (GridDB as a Unified Data and Identity Store, Schema Design for Authentication, Registration and Token Issuance, Protecting Endpoints)
  9. Introduction to GridDB Cloud (What is GridDB Cloud?, On-Premises vs. Managed Service, The Web API, The Broader GridDB Ecosystem)
  10. Serverless Integration with Microsoft Azure IoT Hub (Serverless IoT Architecture, Device Provisioning and Security, Azure Function Ingestion, Best Practices)
  11. Cloud-Native Visualization with Grafana Cloud (The Cloud Advantage, Connecting via the Infinity Plugin, Querying and Visualization)
  12. Streamlining Cloud Management with the GridDB Cloud CLI (Why a CLI, Installation and Configuration, Querying and Introspection, Automation)