[Phpmyadmin-devel] GSOC 2010 Charts

[Martynas Mickevičius]

2010/3/24 Martynas Mickevičius <mmartynas at gmail.com>

> 2010/3/23 Piotr Przybylski <piotr.prz at gmail.com>
>
> 2010/3/23 Marc Delisle <marc at infomarc.info>:
>> > Martynas Mickevičius a écrit :
>> >> Hello everyone,
>> >> I have noticed that you are using git as versioning system. Is there
>> any PMA
>> >> developer using Windows? I am using msysgit and was wondering if there
>> are
>> >> any alternatives.
>> >
>> > I am using Linux, but if you don't find anything that works for you, you
>> > could install Sun's Virtualbox + some Linux distro in a virtual machine.
>> > Works like a charm.
>>
>> Yesterday I successfully cloned phpMyAdmin repository with
>> TortoiseGit, but by using msysgit commandline. Unlike GUI tools it
>> shows me some progress and I know whether it works at all, with 180 MB
>> repository it is good to know whether the task progresses at all. The
>> only problem I have is that some TortoiseGit service crashes about one
>> time per two hours (at least on my Windows 7 x64). I intend to try out
>> GitExtensions - http://code.google.com/p/gitextensions/w/list , maybe
>> it will work better.
>>
>> --
>> Piotr Przybylski
>>
>
> I have tried git extensions today. It is just a simple GUI which connects
> msysgit, putty and kdiff3.
> And I have to say it is really a slow GUI. So I am going back to using
> plain msysgit which works well.
>
> Going back to chart and graph related issues. I guess graphing query
> results could be implemented as yet another table dump format. Also
> bookmarking queries which provide interesting results to be put into charts
> and graphing their results from time to time would prove really useful.
>
> I am not able to figure out how to use bookmarks feature in PMA. I have
> noticed a table in phpmyadmin DB for that. So I looked all over the place of
> SQL query results, but could not find bookmark button.
>
> Another reporting feature, which could be improved is PDF reports. I would
> imagine that adding just a simple font size input box would render this
> feature far more usable.
>
> P.S. Just noticed that the PMA translation of my mother tongue, Lithuanian,
> has not had any input for some time now. Another project to commit for
> translation.
>

There is one more place that I think adding graphs would be beneficial. It
is query profiling information. Simple bar graph would easily show what
stage of query execution takes the most time.

I was also wondering about charts themselves. In ideas list, it was
mentioned that graphs would be drawn using GD2.

Another way is to use Google Chart Tools. These tools offer two different
types of charts.

First one is simple image charts, which are retrieved using GET or POST
queries from Google servers. Another type is Javascript/Flash charts which
offer interactivity but take longer to load.

Since charts would be offered in specific non-mission-critical places of
PMA, loading any type of mentioned two from outside servers should not be a
problem. Also there should be a logic introduced to switch between chart
types by the current browser capabilities.


>
>
>>
>>
>> ------------------------------------------------------------------------------
>> Download Intel® Parallel Studio Eval
>> Try the new software tools for yourself. Speed compiling, find bugs
>> proactively, and fine-tune applications for parallel performance.
>> See why Intel Parallel Studio got high marks during beta.
>> http://p.sf.net/sfu/intel-sw-dev
>> _______________________________________________
>> Phpmyadmin-devel mailing list
>> Phpmyadmin-devel at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20100329/62314668/attachment.html>