It’s a big release for the new year, with many fixes and features!
Here are some key highlights:
- Control the data lifecycle using the new
TTL
feature, automatically dropping old data after a configurable period. - Simplify your queries with the new
DECLARE @var := 'value'
syntax - no longer must you repeat common constants in your queries. Define once, use anywhere! - Enjoy new window functions, including the long awaited
LAG
andLEAD
! - New table metrics monitoring charts, which give you quick and easy access to information about your table performance and health.
- Access table DDLs programmatically, using the new
SHOW CREATE TABLE
command. - Define timestamp filters using correlated subqueries:
WHERE ts > (select min(ts) FROM tbl)
- Parallel execution for queries that source data from Parquet files using the
read_parquet()
function.
For full information, see the release blog and QuestDB GitHub.
Go to our website to upgrade now!
We hope you enjoy these features and look forward to our next release, which will include Materialised Views!
P.S QuestDB has moved - we can now be found at questdb.com!