June 2020 Summaries

QuestDB is an open-source time-series database designed for high-performance workloads with features such as ultra-low latency and high ingestion throughput, making it suitable for environments like trading floors and mission control. The database supports Parquet and SQL, ensuring data portability and avoiding vendor lock-in. This tutorial demonstrates the process of connecting an IoT device, specifically an ESP8266 with a DHT11 sensor, to QuestDB, emphasizing its ease of use compared to InfluxDB. It guides users through setting up QuestDB, creating a table using standard ANSI SQL, and sending sensor data via UDP using InfluxDB line protocol. The tutorial also highlights QuestDB’s schema-on-write capability, allowing data to be stored without predefined schemas. The author plans to integrate the data with tools like Node-Red and Grafana for visualization, encouraging further community engagement and support for the project.