# 🎧 Catch Your Bus with KSQL: A Stream Processing Recipe by Leslie Kurt

**URL:** <https://forum.confluent.io/t/catch-your-bus-with-ksql-a-stream-processing-recipe-by-leslie-kurt/2200>\
**Category:** News and Blogs\
**Created:** [10 July 2021 14:30 UTC](https://forum.confluent.io/t/catch-your-bus-with-ksql-a-stream-processing-recipe-by-leslie-kurt/2200 "2021-07-10T14:30:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![alice.richardson](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/alice.richardson/32/137_2.png) [@alice.richardson](https://forum.confluent.io/u/alice.richardson)\
**Post date:** [10 July 2021 14:30 UTC](https://forum.confluent.io/t/catch-your-bus-with-ksql-a-stream-processing-recipe-by-leslie-kurt/2200/1 "2021-07-10T14:30:13Z")

</div>

_There’s a new Streaming Audio episode - check it out!_

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](https://www.confluent.io/product/ksql/)
- [Stream Processing Cookbook](https://www.confluent.io/stream-processing-cookbook/)
- [KSQL Recipe: Calculating Bus Delay Time](https://www.confluent.io/stream-processing-cookbook/ksql-recipes/calculating-bus-delay-time)

For more, you can check out [ksqlDB](https://ksqldb.io), the successor to KSQL.

* * *

[**🎧 Listen to the episode**](https://developer.confluent.io/podcast/catch-your-bus-with-ksql-a-stream-processing-recipe-by-leslie-kurt?utm_source=buzzsprout&utm_medium=podcast&utm_campaign=ch.episode_type.community_content.share)