questdb/questdb 6.0.5

on GitHub

Release highlights

Release version 6.0.5 introduces support for geospatial data in QuestDB via the addition of geohash types. Geohashes encode geographic areas as base-32 strings, and native support for this type allows for fast and efficient querying and storage of geodata. For more information on geospatial support in QuestDB, including examples and references, see the QuestDB geohash documentation.

Additional features are new timestamp_floor() and timestamp_ceil() functions, improvements on the performance of first() and last() functions, out-of-order parameter support via REST API, and multiple bug fixes. These fixes and features improve application stability and enhance the system's flexibility of use.

What is new

• SQL: implement "touch" function, useful to preload the data from disk into system page cache (#1305)
• SQL: GeoHash type support
• SQL: within SQL operator - SIMD accelerated GeoHash prefix search with time-slice
• SQL: accelerated first() and last() aggregation functions for scanning index
• SQL: GeoHash literal support for character and bitmask
• SQL: allow comparisons between GeoHash and string, for chars notation (#1310)
• SQL: accelerated make_geohash() function (#1265)
• SQL: timestamp_floor() and timestamp_ceil() implementations (#1300)
• Core: new Row API to store GeoHash values (#1311)
• PGWire: add geohash support for PGWire protocol (#1270)
• ILP: add ingest support for type geohash, when schema exists (#1251)
• HTTP: add parameters commitLag and maxUncommittedRows to /imp (#1203)
• UI: basic syntax highlighting for geohashes in web console (#1318)

What we fixed

• SQL: fixed possible incorrect results in group by queries (#1285)
• SQL: throw invalid date exception on negative time interval (#1277)
• SQL: push timestamp required on asof join on both sides (#1225)
• SQL: support SQL keywords as column names (#1267)
• SQL: make SQL functions case-insensitive (#1219)
• O3: fixed race condition that can occur between O3 copy jobs and purge job (#1232)
• O3: row count on TableWriter is wrong when partition start in lag (#1223)
• ILP: review ILP/UDP value parser and fix corner cases (#1289)
• ILP: fixed missing index update when ingesting data over ILP (#1302)
• HTTP: fix writer left locked after CSV upload (#1218)
• Core: virtual memory refactoring (#1208)
• Misc: questdb.sh to work on FreeBSD (#1264)