Usability improvment ideas

<div class="WordSection1"><p class="MsoNormal"><span lang="EN-US">Hi pgadmin team,</span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">I am not sure if this mailing list is suitable for giving
feedbackon pgadmin,</span><p class="MsoNormal"><span lang="EN-US">so please redirect me to a better place if
necessary.</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Pgadmin itself
seemsto be a really nice tool, </span><p class="MsoNormal"><span lang="EN-US">but I think that there is potential to
improveits usability with minor development effort.</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US">1] a "run current query" shortcut</span><p class="MsoNormal"><span lang="EN-US">2]
an"abort query" shortcut</span><p class="MsoNormal"><span lang="EN-US">3] improved shortcut for comment/uncomment
multiplelines</span><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">1] a "run
currentquery" shortcut</span><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US">Wheneveryou have more than one query within the query editor, </span><p class="MsoNormal"><span
lang="EN-US">itis necessary to select the query in order to execute it.</span><p class="MsoNormal"><span
lang="EN-US">Itwould be better if it’s possible to do the same without requiring an initial query selection.</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">My proposal would be to add ctrl+F5
asshortcut, which runs the query surrounding the current cursor position.</span><p class="MsoNormal"><span
lang="EN-US">ctrl+F7would do the same for an explain plan.</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US">It would not break the current behavior because the old way would still
exist.</span><pclass="MsoNormal"><span lang="EN-US">This is most probably easy to implement. </span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Don’t think about a fancy algorithm
tofind the proper query surrounding the cursor.</span><p class="MsoNormal"><span lang="EN-US">Implement it the simplest
availableway: an empty line above or below is the border to identify the query.</span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">If a line contains only whitespaces (tab, space,...) its
qualifiedto limit the query scope.</span><p class="MsoNormal"><span lang="EN-US">An comment-only line should not be
treatedas query border.</span><p class="MsoNormal"><span lang="EN-US">(Complex queries might have full line comments
withinthe query.)</span><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US">Rationale:</span><pclass="MsoNormal"><span lang="EN-US">It allows a user to constantly spam "run query" or
"explainquery" without moving his hands from the keyboard.</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US">I must admit, that it’s hard to see the value without the ability to get a feeling
forit.</span><p class="MsoNormal"><span lang="EN-US">I am not aware of a decent postgresql query tool caring about this
issue.</span><pclass="MsoNormal"><span lang="EN-US">  </span><p class="MsoNormal"><span lang="EN-US">Optional:</span><p
class="MsoNormal"><spanlang="EN-US">The ability to configure the shortcut, because to be honest I like toads ctrl+enter
morethan the idea of ctrl+F5.</span><p class="MsoNormal"><span lang="EN-US">You might think that this makes no
difference,</span><p class="MsoNormal"><span lang="EN-US">but for hitting ctrl+F5 I need to move my arm,</span><p
class="MsoNormal"><spanlang="EN-US">while the other one is reachable with minimal effort (at least at my german
keyboardlayout)</span><p class="MsoNormal"><span lang="EN-US">The same applies to ctrl+e vs. ctrl+F7.</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">2] an "abort query"
shortcut</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">How about using
theescape key to abort the currently running query?</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US">3] improved shortcut for comment/uncomment multiple lines</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">This is a controversial topic,
becauseto be honest I’m not sure if my proposal is a good one.</span><p class="MsoNormal"><span lang="EN-US">The only
thingI know is that your current mechanic feels awkward.</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US">I think what I mostly dislike is: </span><p class="MsoNormal"><span
lang="EN-US">Thecomment of the first line does not appear at the beginning of the first line.</span><p
class="MsoNormal"><spanlang="EN-US">It is always added to the start of the selection.</span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">Currently I use comment/uncomment only within eclipse and
toad.</span><pclass="MsoNormal"><span lang="EN-US">Toad is like pgadmin, but it adds the first comment at the start of
thefirst line.</span><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">But in the
endit would be even nicer if it’s even smarter as it is within eclipse.</span><p class="MsoNormal"><span
lang="EN-US">Itallows using both actions with only one shortcut.</span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">If all lines start with -- => uncomment them. (ignore
whitespacesin front of --)</span><p class="MsoNormal"><span lang="EN-US">If one line within the selection does not
startwith -- => add a comment to all of them.</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><spanlang="EN-US">This behavior might sound little bit odd, </span><p class="MsoNormal"><span
lang="EN-US">butafter using both behaviors regular, </span><p class="MsoNormal"><span lang="EN-US">I would always
preferthe smarter eclipse way.</span><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US">Regards,</span><pclass="MsoNormal"><span lang="EN-US">Bernhard</span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">Sorry for not trying to implement it on my own.</span><p
class="MsoNormal"><spanlang="EN-US">But after 10 years of avoiding c, I doubt that the resulting code would be
helpful.</span></div>