QStudio 4.09 – NEW! Dive-into Nested kdb+ Results.
QStudio 4.09 introduces a number of new features to make exploring data easier than ever.
Column Stats
Allows getting a count of nulls, averages and how many distinct values a column contains by hovering the column header:
Transposed row(s)
Have a very wide table? Want to quickly see all the column?
Transpose from a row to column based layout for those rows. Allowing you to quickly see all values:
Dive-into Nested Results
Double-click on a nested array or kdb structure (table/dict) to pop-out a table showing only the nested item. You can repeat this to dig deeper and deeper into nested data. (Thanks to Oleg/QPad on pioneering this idea).
As well as these new features, a large number of bugs were fixed:
- 4K Monitor support was significantly improved. You have the option to scale the full UI in preferences.
- Apple Mac got a dedicated release and custom App download.
- We upgraded kdb+ c/jdbc.java to allow SSL TLS.
Full Release Info:
All past release changes can be found here.
2025-05-12 – 4.09 – Improve Autocomplete suggestions
– Add namespace listing panel.
– Improve QDoc to add file level details.
2025-04-22 – 4.08 – Bugfix: Candlestick charts were wrong as receiving wrong timezone from kdb driver. Timezone now set to UTC.
– Bugfix: “Save as” to .sql was shrinking text. Now fixed.
– Bugfix: Show red X close on every document tab.
2025-04-06 – 4.07 – Add UI Scaling and Font size as separate options to help with 4K monitors
– Bugfix: Kdb+ Queries with errors could cause 30 second freezes.
– Bugfix: Switch back to MonoSpaced font. Variable width fonts cause wrong caret position.
– Improved high resolution QStudio icon.
– Mac: Bugfix: Prefences dialog fixed and allows choosing font.
– Mac: Fixed Menu shoing about/preferences/exit.
– Mac: Allow Command+Option+E to run current query.
– 4K handling improved sizing of dialogs.
– Bugfix: Improved duckdb init when folder is empty.
2025-03-13 – 4.06 – Add ability to transpose rows.
– DuckDB 1.2.1. Improve display of DuckDB arrays.
– Add comma separator for thousands option.
2025-02-23 – 4.05 – Upgrade kdb+ c/jdbc.java to allow SSL TLS.
– Add preference to allow hiding all tooltips.
– Double-click on kdb+ table with dictionary/table/list nested in cell will pop it out.
2025-01-23 – 4.04 – Show column info (avg/min/max) when column header is hovered.
– Remove watched expressions entirely.
– Improved UI threading for tree/chart display.