[Phpmyadmin-devel] Table charting pChart replacement

[Rouslan Placella]

On Mon, 2011-06-13 at 19:18 +0200, Tyron Madlener wrote:
> On Mon, Jun 13, 2011 at 2:52 PM, Michal Čihař <michal at cihar.com> wrote:
> > Hi
> >
> > Dne Thu, 9 Jun 2011 17:04:30 +0200
> > Tyron Madlener <tyronx at gmail.com> napsal(a):
> >
> >> Current differences over the pChart implementation:
> >> - Everything updates as you type/select. No more Redraw button is required
> >> - New charting types: (Horizontal-)Bar and Spline
> >> - No editable Area/Legend Margins (who needs that?)
> >> - Have as many Series (=Columns-1) as you want, not only 3
> >> - Select the column you want to be the x-axis, so you don't need to
> >> know by heart where in your query result the x-axis column is supposed
> >> to be.
> >> - If a column contains the word date or time it will be pre-selected as xaxis
> >> - No width/height selection, instead just mouse-drag the chart to the
> >> right size.
> >>
> >> Please check it out at http://demo.phpmyadmin.net/gsoc-tyron/
> >
> > Looks nice, thanks!
> >
> > I'd like to merge your changes back to master, any opinions about that?
> 
> I've committed a bunch of fixes for bugs/style glitches that I found.
> I didn't test my stuff with the original theme before.
> 
> There's still some issues that I'd like to mention:
> 
> - Chart export under IE8 still doesn't work yet. Though the canvg
> author told me he would work on it next Sunday.
> - I've just discovered chart export in other browsers is a bit
> glitchy, as canvg ignores the svg element attribute
> visibility="hidden" - however I dug into the canvg code and fixed this
> for text and path elements (which before created a lot of overlapping
> text elements on pie charts). So now there is only this odd cross in
> the upper left corner and some other weird element rendered at the
> bottom center of the image. I've reported this bug and it's fix as
> well. So that might be fixed real soon.
> - On real-time charts, it sometimes happened to me that the refreshing
> stopped after I have exported it. I couldn't reproduce this yet.

Just seen those real-time charts for the first time now. Nice work, that
is so cool! =D

BTW, I noticed that when switching from one tab (say "server traffic")
with real-time chart to another one (say "query statistics") and then
back, the refresh also stops.

> - I'm still not entirely sure of whether the processes table should be
> merged into the status page. I'm currently leaving it there now to get
> the right inspiration what to do with it :-)
> - The chrome console gives me odd errors on highcharts pies: "Error: A
> negative value for rect <height> is not allowed" - this should be a
> bug of highcharts and is I guess some SVG Error (there's not
> stacktrace available).
> - Using 'display chart' on big amounts of data creates a lot of client lag.
> - My branch includes a differently behaving PMA_formatNumber() which
> might affect other areas of pma
> 
> Other than that, I'd be glad to see my changes in master :-)
> 
> >
> >> P.S.: There seems to be a problem when using the sql statements given
> >> on the wiki within the db links SQL page. Once the query is executed
> >> and you click on display chart or export it just redirects you to the
> >> main page again.
> >
> > I've just fixed this in git.
> >
> > --
> >        Michal Čihař | http://cihar.com | http://blog.cihar.com
> >
> > ------------------------------------------------------------------------------
> > EditLive Enterprise is the world's most technically advanced content
> > authoring tool. Experience the power of Track Changes, Inline Image
> > Editing and ensure content is compliant with Accessibility Checking.
> > http://p.sf.net/sfu/ephox-dev2dev
> > _______________________________________________
> > Phpmyadmin-devel mailing list
> > Phpmyadmin-devel at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> >
> >
> 
> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel