Home / Companies / Yugabyte / Blog / Post Details
Content Deep Dive

Develop IoT Apps with Confluent Kafka, KSQL, Spring Boot & Distributed SQL

Blog post from Yugabyte

Post Details
Company
Date Published
Author
Sid Choudhury
Word Count
1,274
Language
English
Hacker News Points
-
Summary

This application is a blueprint for building IoT applications using Confluent Kafka, KSQL, Spring Boot, and YugabyteDB. It provides a real-time dashboard to track fleet management data from IoT-enabled vehicles, including overall distribution of vehicle types per delivery route, most recent subset of these vehicle types per shipment delivery route, and list of vehicles near road closures. The application architecture consists of Confluent Kafka as the streaming platform, YugabyteDB as the distributed SQL database, KSQL for stream processing on Kafka, Spring Boot for the data dashboard, and a program to simulate vehicle events being written into the Kafka stream. The application uses three tables in YugabyteDB to store aggregated data: Total_Traffic, Window_Traffic, and poi_traffic. The data dashboard queries these tables using Web Sockets and jQuery to push data to the webpage in fixed intervals.