QuestDB 6.0.5 September release, geospatial support

QuestDB's latest release, version 6.0.5, introduces geospatial data support through the integration of geohash types, which enables efficient querying and storage of geographic information. Geohashes, which convert geographic locations into short alphanumeric strings, allow for precise spatial data representation and the execution of geospatial queries using new syntax and operators. This update opens up new possibilities for applications in asset tracking, machine learning, and computer vision, among other fields. Additionally, the release includes performance enhancements for the first() and last() functions, which improve efficiency in geospatial queries, particularly those involving "last-known location" scenarios. New functions for rounding timestamps, such as timestamp_floor() and timestamp_ceil(), have been added, providing more flexibility in handling temporal data. The release notes and changelog are available on GitHub, and the version can be accessed via Docker Hub, with the QuestDB team actively seeking community feedback and engagement on the update.