April 2021 Summaries

QuestDB, an open-source time-series database known for its high performance and flexibility, has released an alpha version for its upcoming 6.0 major update, introducing significant new features and improvements. The update includes support for ingesting out-of-order records, an overhaul of the InfluxDB Line Protocol subsystem, and multiple stability enhancements. Key features of this release are the improved compatibility with the Time Series Benchmark Suite, ARM64 support, and various UI and SQL enhancements. These changes aim to enhance the database's adaptability to real-world data challenges, such as network jitter and latency. Additionally, QuestDB is set to benchmark its performance against other databases like InfluxDB, ClickHouse, and TimescaleDB, and invites community feedback and testing in this developmental stage.

QuestDB, an advanced database optimized for market data, offers high ingestion throughput and SQL analytics, making it suitable for tick data and time series analysis. A tutorial by community contributor Yitaek Hwang demonstrates how to stream Ethereum blockchain data into QuestDB for visualization and analysis. This process includes setting up an Infura account to access Ethereum on-chain data, creating tables for blocks and token transfers in QuestDB, and using a Python script to stream data from Infura to QuestDB. The tutorial provides detailed steps on configuring QuestDB for high-performance data handling, using Docker to run QuestDB, and leveraging PostgreSQL wire protocol for data ingestion. The tutorial also discusses handling timestamp data and offers solutions for improving performance, such as modifying the ETL script or using QuestDB's functions to parse timestamps. Additionally, it suggests deploying the streaming application on Kubernetes for scalability and encourages community interaction through feedback and forums.