A Kafka topic with a ksql query on top could be very interesting and offer some real time capabilities