We all know that feeling of waiting when your ride is running late. Leslie Kurt shares about how you can use KSQL to calculate the difference between the expected arrival time and real-time updates of a bus as it executes its route. Listen as Leslie walks you through fundamental concepts like KTables, Kafka Streams, persistent queries and Confluent MQTT Proxy, as well as other use cases that involve a similar mechanism of capturing Unix timestamps and performing a stream processing operation on these timestamps.

EPISODE LINKS

• About KSQL
• Stream Processing Cookbook
• KSQL Recipe: Calculating Bus Delay Time

For more, you can check out ksqlDB, the successor to KSQL.