#1492 (ok 4.3) Remove the distinct query window / Add SQL log+history panel

Next_release
fixed
GSOC 2014 (25)
1
2014-12-05
2014-01-20
No

We no longer need the distinct query window (seperate window opening from the navi panel or from the top Edit link in browse mode).

Its SQL history should be kept and moved to the screen bottom, along with a section always showing the latest SQL query performed.

Related

Feature Requests: #1492

Discussion

  • Umair Khan

    Umair Khan - 2014-01-23

    What's the meaning of GSOC2014 label ?
    It should be implement during GSOC only ?

     
  • Marc Delisle

    Marc Delisle - 2014-01-23

    Yes, the feature has been chosen for GSoC only and is part of the ideas list.

     
  • Marc Delisle

    Marc Delisle - 2014-03-04
    • summary: Remove the distinct query window --> Remove the distinct query window / Add SQL log+history panel
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,3 +1,3 @@
     We no longer need the distinct query window (seperate window opening from the navi panel or from the top Edit link in browse mode).
    
    -Its SQL history should be kept and moved to the SQL page.
    +Its SQL history should be kept and moved to the screen bottom, along with a section always showing the latest SQL query performed.
    
     
  • Aayush

    Aayush - 2014-03-14

    do you mean you want to remove this...?
    please help me out.. i am seriously very much interested for working with you all in gsoc..
    need to complete my proposal letter asap.
    for that i need to get clear with everything.

     
  • Marc Delisle

    Marc Delisle - 2014-03-16

    The section you marked with a red circle shows the last query executed. One aspect of this feature request is about moving this section to the bottom. Another aspect is about removing the distinct query window.

     
  • Aayush

    Aayush - 2014-03-21

    i believe there are two sections of users of PMA
    1. who use PMA to efficiently handle their database. They are not concerned with the code generated. They use the interface provided by PMA to get the desired result.
    but there is another section too.
    2. who use PMA to "write" a lot of queries for them. see https://sourceforge.net/p/phpmyadmin/feature-requests/1145/
    and i have been user of both kind.
    so i believe the decision of removing the sql query box depends upon what is more important to the user. End result when query is run or the query generated.
    so, possible solution could be a checkbox asking if only query is required. If only query is required, then prime importance would be the query and in that case present state of separate query box will work fine.
    however in other case, where end result is more important, query box should me moved down to bottom. So that user can browse the changes brought by query. And if user want to see the query too, can scroll down to it.

     
  • Marc Delisle

    Marc Delisle - 2014-03-21

    Aayush,
    when you write "removing the sql query box", I'm not sure that you mean the same thing as me. I am talking about the "distinct query window", not about a query box.

     
  • Aayush

    Aayush - 2014-03-21

    yes.. i meant same.. sorry for the ambiguity.
    only point i want to raise is this decision of removing the distinct query window and moving it down should depend upon what user is putting more importance on. if on the query generated or output obtained.

     
  • Marc Delisle

    Marc Delisle - 2014-03-21

    It's more a matter of consistency in the interface, by removing this separate window.

     
  • Aayush

    Aayush - 2014-03-21

    yes..
    what would you then suggest..? taking into picture both the fact
    consistency and user requirement

     
  • Marc Delisle

    Marc Delisle - 2014-03-21

    What I suggest is in this feature request. I did not suggest to remove the query box, just to remove its implementation in a distinct query window.

     
  • Aayush

    Aayush - 2014-04-07

    hi marc,
    plz see these two pictures. I was thinking of moving the query window below in the form of something footer type section.
    please see this and comment.
    I feel this will be consistent too. I have been thinking over it.
    But first you see this then I will get in details.

     
  • Marc Delisle

    Marc Delisle - 2014-04-08

    Aayush,
    this is interesting. Does the bottom part also contain the history of queries?

     
    • Aayush

      Aayush - 2014-04-09

      hi Marc,
      i personally feel if query history will be displayed in that footer
      type query box, then the size of footer will increase which might not
      look well.
      But if query history has to be included, then that will be the only best place.
      so, yes we can add the query history there.
      also i would like to focus some features which i am thinking:
      1. i added a green bullet in the right side to show if query was
      successfully executed. otherwise red bullet is displayed if error is
      there in the query.
      2. size of compressed "footer type query box" is fixed. but it is
      expandable and can be compressed again.
      3. if user only wants the query, then by default an expanded footer
      will be displayed which can be compressed. and if query is executed,
      then by default an compressed footer will be displayed which can be
      expanded.
      i feel this will be consistent too

      On 4/9/14, Marc Delisle lem9@users.sf.net wrote:

      Aayush,
      this is interesting. Does the bottom part also contain the history of
      queries?


      [feature-requests:#1492] Remove the distinct query window / Add SQL
      log+history panel

      Status: open
      Group: Next_release
      Labels: GSOC 2014
      Created: Mon Jan 20, 2014 12:57 PM UTC by Marc Delisle
      Last Updated: Mon Apr 07, 2014 07:23 PM UTC
      Owner: Marc Delisle

      We no longer need the distinct query window (seperate window opening from
      the navi panel or from the top Edit link in browse mode).

      Its SQL history should be kept and moved to the screen bottom, along with a
      section always showing the latest SQL query performed.


      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/phpmyadmin/feature-requests/1492/

      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/

      --
      Thanks & Regards
      Aayush
      2nd Year Undergraduate Student
      Department of Mining Engineering
      Indian School of Mines, Dhanbad
      Mobile No: (+91)9162648465

       

      Related

      Feature Requests: #1492

  • Aayush

    Aayush - 2014-08-10
     
    Last edit: Aayush 2014-08-10
  • Marc Delisle

    Marc Delisle - 2014-08-12
    • summary: Remove the distinct query window / Add SQL log+history panel --> (ok 4.3) Remove the distinct query window / Add SQL log+history panel
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-12-05
    • Status: resolved --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks