February 2021 Summaries

QuestDB is an open-source time-series database known for its ultra-low latency and high ingestion throughput, making it suitable for demanding workloads like trading floors and mission control. The guide, contributed by Yitaek Hwang, demonstrates how to stream fitness data into QuestDB using Google Cloud Platform, particularly focusing on utilizing IoT Core and Pub/Sub to manage and secure device communications. The setup involves creating a registry for IoT devices, configuring Pub/Sub topics, and using Docker to run QuestDB, with the data visualization facilitated by Grafana. The process includes setting up a Raspberry Pi with a heart rate sensor to simulate data streaming, which is then processed and stored in QuestDB, allowing for real-time data querying and visualization. This comprehensive tutorial exemplifies an end-to-end system capable of securely streaming and analyzing IoT data, with the potential for scalability and integration with other data visualization tools.

Software version 5.0.6 introduces a comprehensive refactoring of PostgreSQL wire support, enhancing the usability for various libraries and languages by including binary support and enabling the use of prepared statements for efficient repeated queries in languages like Python and Rust. The update also incorporates Grafana alerting through RFC339Nano timestamp format, which aids in monitoring system changes and minimizing disruptions. A built-in function now allows users to easily access server version details for troubleshooting, and the "CREATE TABLE IF NOT EXISTS" feature provides more flexibility by preventing errors when tables already exist. Additionally, improvements have been made to prevent data loss in QuestDB instances in the event of disk space depletion. Users are encouraged to review the full list of updates on GitHub and share their feedback in community forums.