[Phpmyadmin-devel] Navigation integration for Routines, Triggers and Events

[Rouslan Placella]

On Sun, 2011-07-24 at 23:02 +0300, Tyron Madlener wrote:
> On Sun, Jul 24, 2011 at 9:53 PM, Marc Delisle <marc at infomarc.info> wrote:
> > Le 2011-07-24 14:32, Rouslan Placella a écrit :
> >> Hi there,
> >>
> >> I planning to integrate the Routines, Triggers and Events into the
> >> navigation frame. To achieve this I'm thinking about adding another
> >> level to the navigation tree in non-light mode (light mode is
> >> unaffected). So that after expanding a database you might be left with
> >> more items like 'tables', 'indexes', 'routines', 'triggers' and
> >> 'events', which you have in turn expand. Even though triggers are
> >> per-table items and every thing else is a per-database item, I think
> >> that it's best to show these on a per-database basis in order to avoid
> >> another level in the navigation. Please find an initial mock-up for this
> >> feature in the attachment. Your thoughts?
> >>
> >> Rouslan
> >
> > It's interesting but as the light mode is the default, I'm afraid that
> > this feature won't be seen by many.
> >
> > Can't you show routines, triggers and events also in light mode, (maybe)
> > with an expansion mechanism?
> >
> > The main idea of the light mode is not to avoid displaying expansion
> > mechanisms, it's to avoid performance issues so it fetches only the
> > tables of the current database.

I see. So, you are asking to add the expansion mechanism to the light
mode and load content for it via ajax for each click on "+". I guess
that would be better, but I think that I might have to come up with a
better logic for handling refreshes. Also, with ajax disabled, the light
mode will basically then fall back to what we have now.

> I agree, but I think they should only be displayed if they have been
> set up previously. (e.g. don't show triggers when there's no triggers
> for that database), assuming that checking this doesn't affect the
> performance too much.

I personally think that this should be a configuration setting.
Something like 'LeftFrameShowAddButton'. The idea is that, with this
setting set to true, each group ('Tables', 'Routines', etc) will have a
"Add new" button at the top of the list. Which means that every
subcategory will be shown in this case. With that setting set to false,
the "Add new" button will not be shown and empty groups will
consequently also not be shown.

Sounds good? Thoughts?

Rouslan