{"id":112021,"date":"2025-05-12T18:53:57","date_gmt":"2025-05-12T18:53:57","guid":{"rendered":"https:\/\/www.timestored.com\/b\/?p=112021"},"modified":"2025-05-14T13:28:10","modified_gmt":"2025-05-14T13:28:10","slug":"qstudio-3-09-new-dive-into-nested-kdb-results","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/qstudio-3-09-new-dive-into-nested-kdb-results\/","title":{"rendered":"QStudio 4.09 &#8211; NEW! Dive-into Nested kdb+ Results."},"content":{"rendered":"<p>QStudio 4.09 introduces a number of new features to make exploring data easier than ever.<\/p>\n<h4>Column Stats<\/h4>\n<p>Allows getting a count of nulls, averages and how many distinct values a column contains by hovering the column header:<br \/>\n<img loading=\"lazy\" class=\"alignnone size-large\" src=\"https:\/\/www.timestored.com\/qstudio\/help\/images\/table-sorting.png\" width=\"1152\" height=\"255\" \/><\/p>\n<h4>Transposed row(s)<\/h4>\n<p>Have a very wide table? Want to quickly see all the column?<br \/>\nTranspose from a row to column based layout for those rows. Allowing you to quickly see all values:<br \/>\n<img loading=\"lazy\" class=\"alignnone size-large\" src=\"https:\/\/www.timestored.com\/qstudio\/help\/images\/table-transposed.png\" width=\"1149\" height=\"434\" \/><\/p>\n<h4>Dive-into Nested Results<\/h4>\n<p>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).<br \/>\n<img loading=\"lazy\" class=\"alignnone size-large\" src=\"https:\/\/www.timestored.com\/qstudio\/help\/images\/table-nested-click.png\" width=\"1514\" height=\"617\" \/><\/p>\n<p>As well as these new features, a large number of bugs were fixed:<\/p>\n<ul>\n<li>4K Monitor support was significantly improved. You have the option to scale the full UI in preferences.<\/li>\n<li>Apple Mac got a dedicated release and custom <a href=\"https:\/\/www.timestored.com\/qstudio\/files\/qstudio-mac.zip\">App download<\/a>.<\/li>\n<li>We upgraded kdb+ c\/jdbc.java to allow <a href=\"https:\/\/www.timestored.com\/qstudio\/help\/ssl-configuration\">SSL TLS<\/a>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Full Release Info:<\/h3>\n<p>All past release changes can be found <a href=\"https:\/\/www.timestored.com\/qstudio\/help\/releases\">here<\/a>.<\/p>\n<p><code><\/code><\/p>\n<p>2025-05-12 &#8211; 4.09 &#8211; Improve Autocomplete suggestions<br \/>\n&#8211; Add namespace listing panel.<br \/>\n&#8211; Improve QDoc to add file level details.<\/p>\n<p>2025-04-22 &#8211; 4.08 &#8211; Bugfix: Candlestick charts were wrong as receiving wrong timezone from kdb driver. Timezone now set to UTC.<br \/>\n&#8211; Bugfix: &#8220;Save as&#8221; to .sql was shrinking text. Now fixed.<br \/>\n&#8211; Bugfix: Show red X close on every document tab.<\/p>\n<p>2025-04-06 &#8211; 4.07 &#8211; Add UI Scaling and Font size as separate options to help with 4K monitors<br \/>\n&#8211; Bugfix: Kdb+ Queries with errors could cause 30 second freezes.<br \/>\n&#8211; Bugfix: Switch back to MonoSpaced font. Variable width fonts cause wrong caret position.<br \/>\n&#8211; Improved high resolution QStudio icon.<br \/>\n&#8211; Mac: Bugfix: Prefences dialog fixed and allows choosing font.<br \/>\n&#8211; Mac: Fixed Menu shoing about\/preferences\/exit.<br \/>\n&#8211; Mac: Allow Command+Option+E to run current query.<br \/>\n&#8211; 4K handling improved sizing of dialogs.<br \/>\n&#8211; Bugfix: Improved duckdb init when folder is empty.<\/p>\n<p>2025-03-13 &#8211; 4.06 &#8211; Add ability to transpose rows.<br \/>\n&#8211; DuckDB 1.2.1. Improve display of DuckDB arrays.<br \/>\n&#8211; Add comma separator for thousands option.<\/p>\n<p>2025-02-23 &#8211; 4.05 &#8211; Upgrade kdb+ c\/jdbc.java to allow SSL TLS.<br \/>\n&#8211; Add preference to allow hiding all tooltips.<br \/>\n&#8211; Double-click on kdb+ table with dictionary\/table\/list nested in cell will pop it out.<\/p>\n<p>2025-01-23 &#8211; 4.04 &#8211; Show column info (avg\/min\/max) when column header is hovered.<br \/>\n&#8211; Remove watched expressions entirely.<br \/>\n&#8211; Improved UI threading for tree\/chart display.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[2,92],"tags":[88,12],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112021"}],"collection":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/comments?post=112021"}],"version-history":[{"count":4,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112021\/revisions"}],"predecessor-version":[{"id":112025,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/112021\/revisions\/112025"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=112021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=112021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=112021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}