{"id":1844,"date":"2009-10-05T08:00:00","date_gmt":"2009-10-05T16:00:00","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/?p=1844"},"modified":"2009-10-05T08:49:38","modified_gmt":"2009-10-05T16:49:38","slug":"primalsql-querying-a-major-update","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2009\/10\/05\/primalsql-querying-a-major-update\/","title":{"rendered":"PrimalSQL: Querying a major update"},"content":{"rendered":"<p>Last month we released a major service update for PrimalForms 2009. This month we will release a major service update for PrimalSQL 2009*.<\/p>\n<p><a href=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2009\/10\/PrimalSQL20091.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"PrimalSQL2009\" src=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2009\/10\/PrimalSQL2009_thumb1.png\" border=\"0\" alt=\"PrimalSQL2009\" width=\"244\" height=\"152\" \/><\/a><\/p>\n<p><strong>What querying goodness will this update include?<\/strong><\/p>\n<p>We made some major improvements to way PrimalSQL queries databases, as well as, a few other changes and additions. Users may experience improved query performance with PrimalSQL\u2019s new asynchronous queries.<\/p>\n<p><strong>What do asynchronous queries mean to me, the user?<\/strong><\/p>\n<p>Well it means that when you run a query, you no longer have to wait until the query completes. Therefore, you can perform multiple operations at the same time, including running more than one query at a time.<\/p>\n<p><strong>What else will this major service release include?<\/strong><\/p>\n<p>In addition to asynchronous queries, PrimalSQL 2009 v1.1.0 will include the following:<\/p>\n<p><strong>New Stop Query Button:<\/strong><\/p>\n<p>Have you ever \u201caccidently\u201d (because you will never do this intentionally) queried a select all statement on a table that has millions of records? Well you need not worry anymore. You will have the ability to stop those rogue queries in their tracks with the new \u201cStop Query\u201d button.<\/p>\n<p><strong>New Toggle Output Editing Button:<\/strong><\/p>\n<p>Another addition will be the new \u201cToggle Output Editing\u201d button, which allows you to quickly switch the Editing\/ Read Only mode of the query results. This setting is will also be stored with your saved query files. Although this option will allow you to quickly modify database entries, you can drastically improve query speeds by disabling Output Editing.<\/p>\n<p><a href=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2009\/10\/RibbonMenu.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; display: inline; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" title=\"New Ribbon Buttons\" src=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2009\/10\/RibbonMenu_thumb.png\" border=\"0\" alt=\"New Ribbon Buttons\" width=\"258\" height=\"95\" \/><\/a><\/p>\n<p>(Figure 1: New Ribbon Buttons: \u201cStop Query\u201d and \u201cToggle Output Editing\u201d)<\/p>\n<p><strong>Default Document Type:<\/strong><\/p>\n<p>You will also have the option to change the default document type when using the New File command. With this new option, PrimalSQL can open with a SQL Document instead of the default Query Builder.<\/p>\n<p><strong>Other Changes:<\/strong><\/p>\n<p>Other improvements in this service release will include Unicode support, faster export speeds, and quicker output scrolling for slower database connections. Below you will find the release notes for the upcoming PrimalSQL 2009 v1.1.0 service build.<\/p>\n<p><strong>Version 1.1.0 Release Notes:<\/strong><\/p>\n<p>ADD: Asynchronous Queries<br \/>\nADD: Ribbon button to stop the running query<br \/>\nADD: Toggle Output Editing Button to Ribbon (Ctrl + T) (Triggers a re-query)<br \/>\nADD: Unicode support (Connections edited or created in this version are not backwards compatible)<br \/>\nADD: Option to specify the default document type when using the New File command<br \/>\nADD: Can now drag and drop connections into the SQL Edit<br \/>\nFIX: Column Autosize<br \/>\nUPD: Now hiding the Left tree panel of the Query Builder by default<br \/>\nUPD: Change the PrimalSense List trigger to (Ctrl + Space)<br \/>\nUPD: Improved Export Speed<br \/>\nUPD: Queries run faster with the Read Only option enabled<br \/>\nUPD: Copy Connection String shortcut changed to Ctrl + Alt + C<br \/>\nUPD: Can now edit, rename, and delete connections while they are loading<br \/>\nUPD: Other minor updates and fixes<\/p>\n<p>*Please note that this month\u2019s service builds will be released on a later date than the scheduled Patch Tuesday date (first Tuesday of the month).<\/p>\n<p>Please go to <a href=\"http:\/\/my.sapien.com\">http:\/\/my.sapien.com<\/a> to download the latest builds of your SAPIEN products.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last month we released a major service update for PrimalForms 2009. This month we will release a major service update for PrimalSQL 2009*. What querying goodness will this update include? We made some major improvements to way PrimalSQL queries databases, as well as, a few other changes and additions. Users may experience improved query performance [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[21],"tags":[1004,155,38],"class_list":["post-1844","post","type-post","status-publish","format-standard","hentry","category-software-news","tag-primalsql","tag-service-release","tag-sql"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=1844"}],"version-history":[{"count":8,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1844\/revisions"}],"predecessor-version":[{"id":1847,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/1844\/revisions\/1847"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=1844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=1844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=1844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}