Practical Pipelines: A Houseplant Soil Alerting System with ksqlDB
summary
Project builds a houseplant soil alert system that streams capacitive moisture and temperature readings from a Raspberry Pi into a managed Apache Kafka cluster, enriches them with plant metadata (Avro schemas), and runs joins and a six‑hour tumbling window in ksqlDB that emits an alert when >120 low readings accumulate (≈1 hour). Alerts go to a phone via Kafka Connect to a Telegram bot. Prototype uses four sensors, 5s→30s sampling, and successfully delivers real‑time warnings.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:08Houseplants need streaming
- 5:42What is Kafka
- 11:38Kafka architecture
- 20:19Plant monitoring design
- 26:20Data and schema design
- 31:15Producer API vs Kafka Connect
- 36:49Stream processing options
- 41:46Setting up ksqlDB
- 47:28Windowed query alerts
- 51:22Alerts to Telegram
- 53:27Telegram plant management
- 59:08Scaling and future
- 1:03:23Q&A
related talks
53mPractical Pipelines: Houseplant Soil Alerting System with ksqlDB
52mPractical Pipelines: A Houseplant Alerting System with ksqlDB
31mPractical Pipelines: A Houseplant Alerting System with ksqlDB.
45mPractical Cloud Pipelines
20mSet your data streams in motion in the ocean!
47mBuilding a Telegram bot with Apache Kafka and ksqlDB
54mAutomating & Monitoring Seedling Growth in the Cloud Using IoT, Messaging & Micronaut
26mBuilding a Telegram bot with Apache Kafka and ksqlDB