Release overview

This is the long-awaited release with UPDATE functionality. We fully implemented UPDATE syntax, which is compatible with PostgreSQL.

Gotchas

None when you are upgrading from the start or 6.3. It is just software update. If you're upgrading from 6.2.1 or earlier, please refer to the gotchas of 6.3

What is new

SQL

• introduce UPDATE SQL statement by @glasstiger and @ideoma in https://github.com/questdb/questdb/pull/1947
• add new SQL command REINDEX to re-index symbol column by @ideoma in https://github.com/questdb/questdb/pull/2142

CORE

• implement the write amplification metric in TableWriter by @amunra in https://github.com/questdb/questdb/pull/2136

What we fixed

CORE

• fix initial connection properties parser by @jerrinot in https://github.com/questdb/questdb/pull/2131
• fix possible ignore of async table ALTER commands by @ideoma in https://github.com/questdb/questdb/pull/2137

SQL

• fix uncommon potential race in parallel filter execution by @puzpuzpuz in https://github.com/questdb/questdb/pull/2134

HTTP

• make /exp endpoint only allow SELECT statements by @MatthewLENG2002 in https://github.com/questdb/questdb/pull/2145

Contributor's Hall of Fame

We want to thank our new contributors:

• @MatthewLENG2002 made their first contribution in https://github.com/questdb/questdb/pull/2145
• @ngnic made their first contribution in https://github.com/questdb/questdb/pull/2150

Full Changelog: https://github.com/questdb/questdb/compare/6.3.1...6.4