#1534 Comments for databases, tables, columns

Needs_decision
open
nobody
Normal
2015-05-15
2014-07-08
gavrilow
No

Hi everyone!

For 10 years the use of phpMyAdmin really want to see the comments to display database and table next to their name. Modifications looked not much. Please do.
foobar

1 Attachments

Discussion

  • Marc Delisle

    Marc Delisle - 2014-07-11

    Hi,
    first, the title of the feature request is misleading, it probably should be "Comments for databases, tables and columns".

    Second, in the 3.5 family, there was a ShowTooltip directive that permitted to show table comments as a tooltip (hovering over the table name) in the navigation panel. But during the 4.0 cycle, this feature was removed for performance reasons:

    https://github.com/phpmyadmin/phpmyadmin/commit/1084e4dfddf6872f9eb11d9ce5375ba4f484f2e1

     
  • Isaac Bennetch

    Isaac Bennetch - 2014-07-11

    I'm not sure how you could balance the length of the comment displayed against the size of the navigation panel. You wouldn't want to expand the navigation panel endlessly, for instance, if there's a really long comment. To me, it seems the ShowTooltip directive was the ideal way to handle this; but with the new navigation style performance is a big concern for pulling these with large numbers of databases or tables.

    I'm not sure this is something that we've seen much interest in.

     
  • gavrilow

    gavrilow - 2014-07-13

    Yes, the performance is slightly reduced. And this option to make the default display is disabled.

    Create four settings:
    1. Show comment next to the table name, the database ...
    2. Show comment titled table name, databases, ...
    3. Shows the tooltip comment.
    4. Completely replace real name table name, databases, ... to comment.

     
  • Aayush

    Aayush - 2015-03-20

    Hi, I feel it should be done. Comments are made to provide additional knowledge, which should be shown at the list.
    and to balance the length of the comment displayed against the size of the navigation panel, we can restrict the length of comment displayed and add an onmouseover function which will display the entire comment once the mouse point is on that comment.
    If you all liked the idea, then I would like to start working on this

     
    • Marc Delisle

      Marc Delisle - 2015-03-21

      AAyush,
      we are very concerned about performance, so if you make initial tests, try a large number of databases/tables/columns and report your findings.

       
  • Marc Delisle

    Marc Delisle - 2015-03-21
    • summary: Comments for spreadsheets, databases, fields --> Comments for databases, tables, columns
     
  • Aayush

    Aayush - 2015-03-21

    thanks for enlightening me. I will be back with my finding.

     
  • Philippe Cloutier

    Table comments in the navigation panel were rejected in #1462.