September 2022 Summaries

Hacktoberfest 2022 offers an opportunity for open-source contributors to engage with projects like QuestDB, a high-performance time series database built from scratch in Java and C++ without dependencies. Participants in Hacktoberfest can earn rewards such as a special-edition T-shirt or a tree planted in their name by completing contributions, which can include code improvements and non-code activities like documentation or tutorials. QuestDB, known for its optimized ingestion and fast SQL queries, is welcoming contributions to three of its projects, including its core database and web console. Prospective contributors are encouraged to follow guidelines, focus on existing issues, and engage with the community through various platforms like community forums and social media. Additionally, QuestDB offers an extra T-shirt through its swag program for contributors who successfully submit a valid pull request.

QuestDB's latest update, version 6.5, introduces a highly optimized CSV file import feature using the SQL COPY statement, significantly enhancing the speed and efficiency of data ingestion. Leveraging io_uring, a modern asynchronous I/O interface, QuestDB has improved its import performance, surpassing several well-known OLAP and time-series databases in the ClickBench benchmark, with only ClickHouse achieving faster results. The new import method, which processes data in parallel through multiple phases, has reduced import times dramatically, particularly when using high-memory setups or NVMe SSDs. This update allows for in-order data ingestion and reduces the need for complex partition re-writes, optimizing data layout on disk for immediate querying. The improvements in QuestDB's import capabilities were driven by insights gained from the ClickBench benchmark, which also highlighted opportunities for enhancing query stability and performance. The update positions QuestDB closer to a practical alternative to ClickHouse for time-series data analysis and sets the stage for further innovations, including potential applications of io_uring in QuestDB Cloud.