Demo geospatial and timeseries queries on 250k unique devices
Blog post from QuestDB
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.