Jump to content


Photo

Sql Query Block Collpse Feature - Disable?


  • Please log in to reply
3 replies to this topic

#1 classaxe

classaxe

    Member

  • Members
  • PipPip
  • 16 posts
  • Gender:Male
  • Location:Richmond Hill, ON, Canada
  • Interests:PHP, MySQL and Christianity (but not necessarily in that order)

Posted 01 November 2010 - 06:33 PM

Hi there,

I love the product and check your blog at least daily, excitedly looking for what's new.

I'm very intrigued by the query expand / contract feature that takes a line like this:
1 UPDATE `system` SET `system`.`db_detail` =
2  CONCAT(
3    'action|dcac4f55, ',
4    'group_members|53eeffac, ',
5    'poll_choice|dc7f1974, ',
6    'DB_visits.visitor_stats|a1d1f931, '
7    'DB_media.media|2d9994f1'
8  );
9
and adds ability to collapse the code block like this:
1 UPDATE `system` SET `system`.`db_detail` =
2 [+]  CONCAT(
---------------------------------------------
9

I have three small comments on my first impressions (and please feel entirely free to disregard these)

1) For readability it might be nice to have the collapsed block shown like this:
1 UPDATE `system` SET `system`.`db_detail` =
2 [+]  CONCAT(...);
---------------------------------------------
9

2) For the sake of completeness, and to really be able to get the most from this feature, I'd be happy to see a right-click shortcut menu entry to 'Expand all / Collapse all'.

3) Also, I know that when you've introduced new features like that in the past, you usually allow people to 'disable' features in 'Tools / Preferences', but I don't see this listed there this time.

Meanwhile, keep up the good work and thanks for your constant improvements and endless attention to detail.

I love the new 'Form' mode for data-entry too - brilliant!

Blessings,

Martin Francis
<><

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 01 November 2010 - 06:57 PM

1) I do not thin that we will add "..." or similar 'placeholder-stringt' that was not in the original query.  the + sign should be enough I believe.

2) Reasonable request.  But I do not know exactly where this context menu should be enabled (on the +/- sign only?) and what is possible. We depend on Scintilla editor/library functionalities.

3) We also did not make "paranthesis'es matching" optional from 'preferences' either.  I think both will not disturb anybody.




But thanks for your comments.  And once we release 8.7 GA more people will start use it and we will undoubtedly get more comments.  We will discuss and summarize after a few months if some changes in the implementation is required.


Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 classaxe

classaxe

    Member

  • Members
  • PipPip
  • 16 posts
  • Gender:Male
  • Location:Richmond Hill, ON, Canada
  • Interests:PHP, MySQL and Christianity (but not necessarily in that order)

Posted 01 November 2010 - 08:53 PM

1) I do not thin that we will add "..." or similar 'placeholder-stringt' that was not in the original query.  the + sign should be enough I believe.

Okay then, although perhaps the bracket highlighting would look more correct when it was able to display and thus highlight the end bracket too. If you ever did decide to add a ... placeholder, that might also be made to act as an expander control. But I'm very happy with whatever you decide, so don't worry about explaining your descision if you decide not to.

2) Reasonable request.  But I do not know exactly where this context menu should be enabled (on the +/- sign only?) and what is possible. We depend on Scintilla editor/library functionalities.

I was thinking on the context menu displayed when one right-clicks anywhere over the sql query

Thanks, have a good one

Blessings,

Martin
<><

#4 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 01 November 2010 - 09:32 PM

Please be patient.  As long as a 8.7 GA is not released only around 5% of users will use 8.7. After GA there will be much more feedback.  For efficient workflow we will 'wait and see' a short while to see what more comments/requests/proposals we will get.

But still thanks for your comments here.  I understand that you like the new 'folding' feature.


Computers make your grey hair come off ....

Peter Laursen
Webyog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users