{"id":111814,"date":"2024-04-09T13:26:44","date_gmt":"2024-04-09T13:26:44","guid":{"rendered":"https:\/\/www.timestored.com\/b\/?p=111814"},"modified":"2024-04-09T13:27:03","modified_gmt":"2024-04-09T13:27:03","slug":"pulse-news-april-2024","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/pulse-news-april-2024\/","title":{"rendered":"Pulse News &#8211; April 2024"},"content":{"rendered":"<p><a href=\"https:\/\/www.timestored.com\/pulse\"><img loading=\"lazy\" class=\"size-full wp-image-111583 aligncenter\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2022\/11\/pulse.png\" alt=\"\" width=\"321\" height=\"66\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2022\/11\/pulse.png 321w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2022\/11\/pulse-300x62.png 300w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/><\/a><\/p>\n<p>It&#8217;s approaching 2 years since we launched Pulse and it&#8217;s a privilege to continue to listen to users and improve the tool to deliver more for them. A massive thanks to everyone that has joined us on the journey. This includes our free users, who have provided a huge amount of feedback. We are commited to maintaining a free version forever.<\/p>\n<p>We want to keep moving at speed to enable you to build the best data applications.<br \/>\nBelow are some features we have added recently.<\/p>\n<p><a href=\"https:\/\/www.timestored.com\/pulse\/help\/table-pivot\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-111819\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/pivt.png\" alt=\"\" width=\"601\" height=\"305\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/pivt.png 601w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/pivt-300x152.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<h2><a href=\"https:\/\/www.timestored.com\/pulse\/help\/table-pivot\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/timestored.us6.list-manage.com\/track\/click?u%3Ddd21f3c286626a64a81a866db%26id%3D08a432e9d0%26e%3D29ad2ccaff&amp;source=gmail&amp;ust=1712754402001000&amp;usg=AOvVaw30GgJJZJTjHFR9XXAmEWZK\"><strong>Pivot Like a Pro<\/strong><\/a><\/h2>\n<p>Pulse enables authors to simply write a select query, then choose columns for group-by, pivot and aggregation. Users can then change the pivoted columns to get different views of the data. The really technical cool part is:<\/p>\n<ul>\n<li>Unlike other platforms, Pulse does not attempt to pull back all data.<\/li>\n<li>All aggregation of data is performed on the SQL server, making it really fast.<\/li>\n<li>For kdb+, aggregation and pivoting occur on the kdb+ end using the common piv function.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.timestored.com\/pulse\/help\/query-caching\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-111817\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/enterprise-query-caching.jpg\" alt=\"\" width=\"854\" height=\"480\" data-wp-editing=\"1\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/enterprise-query-caching.jpg 854w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/enterprise-query-caching-300x169.jpg 300w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/enterprise-query-caching-768x432.jpg 768w\" sizes=\"(max-width: 854px) 100vw, 854px\" \/><\/a><\/p>\n<h2><a href=\"https:\/\/www.timestored.com\/pulse\/help\/query-caching\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/timestored.us6.list-manage.com\/track\/click?u%3Ddd21f3c286626a64a81a866db%26id%3D4726692204%26e%3D29ad2ccaff&amp;source=gmail&amp;ust=1712754402001000&amp;usg=AOvVaw0AXuHGkf2dT7fwYbRrKQMu\"><strong>Caching for Faster Results and Less load<\/strong><\/a><\/h2>\n<ul>\n<li>As we have deployed Pulse at larger firms with more users, the backend databases began to become a bottleneck.<\/li>\n<li>Polling queries to data sources can now be <a href=\"https:\/\/www.timestored.com\/pulse\/help\/query-caching\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/timestored.us6.list-manage.com\/track\/click?u%3Ddd21f3c286626a64a81a866db%26id%3D08d62ad163%26e%3D29ad2ccaff&amp;source=gmail&amp;ust=1712754402001000&amp;usg=AOvVaw3Yrn_HKYHXc1h6SFdfV2fs\">cached and results reused<\/a> within the time intervals selected.<\/li>\n<li>This means whether there are 1, 10 or 100 users looking at the same dashboard with the same variables, it will only query once, not separately for every user.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.timestored.com\/pulse\/help\/dashboard-version-history\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-111818\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/diff.png\" alt=\"\" width=\"741\" height=\"130\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/diff.png 741w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/diff-300x53.png 300w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/><\/a><\/p>\n<h2><a href=\"https:\/\/www.timestored.com\/pulse\/help\/dashboard-version-history\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/timestored.us6.list-manage.com\/track\/click?u%3Ddd21f3c286626a64a81a866db%26id%3Dd5b481a04b%26e%3D29ad2ccaff&amp;source=gmail&amp;ust=1712754402001000&amp;usg=AOvVaw0ac7-9D36OieUu-cih6RqU\"><strong>What Changed? Diff.<\/strong><\/a><\/h2>\n<ul>\n<li>Pulse has allowed users to open or restore previous versions since version 1.<\/li>\n<li>Now you can <strong>view a diff<\/strong> to see which code or query changed.<\/li>\n<li>Next we want to add support for file\/git based deployment.<\/li>\n<li>If this is something that interests you, add a note to the <a href=\"https:\/\/timestored.us6.list-manage.com\/track\/click?u=dd21f3c286626a64a81a866db&amp;id=b5684e2313&amp;e=29ad2ccaff\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/timestored.us6.list-manage.com\/track\/click?u%3Ddd21f3c286626a64a81a866db%26id%3Db5684e2313%26e%3D29ad2ccaff&amp;source=gmail&amp;ust=1712754402001000&amp;usg=AOvVaw2r-AcNpoKGAD1fQklZbxCW\">issue<\/a>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.timestored.com\/pulse\/help\/faq\/tabs-sheets\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-111821\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/tabes-sheets.png\" alt=\"\" width=\"779\" height=\"231\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/tabes-sheets.png 779w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/tabes-sheets-300x89.png 300w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2024\/04\/tabes-sheets-768x228.png 768w\" sizes=\"(max-width: 779px) 100vw, 779px\" \/><\/a><\/p>\n<h2><a href=\"https:\/\/www.timestored.com\/pulse\/help\/faq\/tabs-sheets\" target=\"_blank\" rel=\"noopener\" data-saferedirecturl=\"https:\/\/www.google.com\/url?q=https:\/\/timestored.us6.list-manage.com\/track\/click?u%3Ddd21f3c286626a64a81a866db%26id%3D46184a5154%26e%3D29ad2ccaff&amp;source=gmail&amp;ust=1712754402001000&amp;usg=AOvVaw3EWUnlsUZ5viTBEXYpiS-_\"><strong>Tabs and Sheets<\/strong><\/a><br \/>\nPulse now supports both a tabbed interface and top level sheets.<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>It&#8217;s approaching 2 years since we launched Pulse and it&#8217;s a privilege to continue to listen to users and improve the tool to deliver more for them. A massive thanks to everyone that has joined us on the journey. This includes our free users, who have provided a huge amount of feedback. We are commited [&hellip;]<\/p>\n","protected":false},"author":4,"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,109],"tags":[],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111814"}],"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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/comments?post=111814"}],"version-history":[{"count":2,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111814\/revisions"}],"predecessor-version":[{"id":111823,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111814\/revisions\/111823"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=111814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=111814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=111814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}