[Phpmyadmin-devel] Table charting pChart replacement

[Tyron Madlener]

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.
- 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
>
>