Release 5.0.3 · questdb/questdb

Release highlights

We improved PostgreSQL wire protocol to support more clients, such as C, Go, Python and NodeJS
We improved performance of memory reads across the board. See our blog here

SQL: LIKE implementation #476 (#512) Abhishek Pratap Singh*
SQL: added count(string), count(symbol) and count(long256). Also added rnd_long256(count) (#556)
SQL: contiguous memory implementation (#538), across the board performance improvement
SQL: added millisecond sampling ('T') (#553
SQL: insert statement accepts timestamp as string in both micro- and milli formats.
SERVER: introduced version of web console and removed -f command line arg (#528
SERVER: set default shared worker pool size to cpu count - 1 (#521)
EMBEDDED simplified embedded API (#539)
PG Wire: implemented protocol correctness. Fixes #450 (#544)
PG Wire: parameter type inferring from parameter values, support NodeJS bind variables. Fixed (#290)

SQL: drop table fix. Fixed #559 (#565)
SQL: as of join failed when timestamp was not in select clause (#560)
SQL: fixed timestamp propagation to join models (#558)
SQL: fix memory leak in LimitRecordCursorFactory (#554)
SQL: fixed issues with long NULL converting to double NULL. Also fixed group-by validation logic to deal with clauses more systematically. Fixed #540 (#545)
SQL: fixed incorrect column referencing from index-based filter implementation (#542)
SQL: fixed 'with' clause behaviour in set operations (union, expct, intersect), in recursive 'with' and in sub-queries (#541)
TCP ILP: change ILP TCP connection defaults to never disconnec (#533)
SQL: timezone parser could fail with unhandled exception (#536)
SQL: simplified symbol table access from record cursors (#530)
SERVER: fixed issue with bad request getting stuck in infinite loop
SERVER: removed gc logging that was causing issues in macOS
PACKAGE:fixed name of directory inside of 'no-jre' archive to match name of the archive