October 2021 Summaries

The latest update to the database introduces geospatial support, allowing users to manage data with spatial and time components, which is particularly valuable for those working with geospatial data who face performance challenges or require tools to track changes in geodata over time. Implemented in software release version 6.0.5, the feature leverages geohashes, which divide the Earth into grids represented by alphanumeric strings, to manage spatial data with varying precision. A demo instance is available for users to test these capabilities, which include optimized query execution for moving objects, using time-based searches followed by geohash lookups to enhance performance. The update also introduces a "within" operator for efficiently sampling data sets in terms of time and space, enabling real-time mapping applications. The database employs a unique storage model for geohashes, optimizing storage and query performance by categorizing geohashes based on their bit-length and utilizing SIMD-based data processing for efficient prefix matching. While the implementation addresses many challenges, such as data noise from stationary updates, the developers continue to refine the system and welcome feedback through their community forum and GitHub.

Hacktoberfest 2021 marks a significant event for QuestDB as they participate for the first time in this month-long celebration dedicated to open source software and communities. The event encourages contributions to open source projects with rewards such as a special edition T-shirt or the option to plant a tree, highlighting the importance of supporting projects often maintained by a small number of developers. QuestDB invites contributors to engage with their core project and provides resources such as a community forum and documentation for support, while also offering additional swag for successful contributions. Participants are encouraged to have a GitHub or GitLab account, sign up on the Hacktoberfest website, and look for repositories opting into the event, with guidance on how to start contributing effectively.