[Phpmyadmin-devel] GSOC 2010 Charts
Hello everyone, my name is Martynas, and I am thinking about participating in GSOC 2010. I have to say that I am happy to see PMA in the accepted projects list. I was looking through the proposed ideas list for PMA and charts idea really caught my interest. Charts in the server status page would be nice to have. I have quickly glanced through the code in server_status.php. It seems that there are just a few statistical values available from DB server that are worth putting to the charts. Most of the values in the server status page are approximated. I have also came up with another idea about charts. What would you think of plotting a result of more or less any SQL query? There have been lots of situations when I tracked some "development" in my database and seeing a graph/chart instead of a result table would have been much nicer. I will also try to look through the bug tracker/feature request list to see if there is something I could get my hands on quickly. 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. Looking forward for you comments. Martynas
Martynas Mickevičius a écrit :
Hello everyone,
my name is Martynas, and I am thinking about participating in GSOC 2010. I have to say that I am happy to see PMA in the accepted projects list.
I have also came up with another idea about charts. What would you think of plotting a result of more or less any SQL query? There have been lots of situations when I tracked some "development" in my database and seeing a graph/chart instead of a result table would have been much nicer.
I have been thinking about this for a few years and I approve your idea. I'm not sure how far we should grow phpMyAdmin into a reporting tool but we already have some kind of reports (for example, PDF export) so I think this could be acceptable.
I will also try to look through the bug tracker/feature request list to see if there is something I could get my hands on quickly.
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.
Looking forward for you comments.
Martynas
-- Marc Delisle http://infomarc.info
2010/3/23 Marc Delisle <marc@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
2010/3/23 Piotr Przybylski <piotr.prz@gmail.com>
2010/3/23 Marc Delisle <marc@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.
------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
2010/3/24 Martynas Mickevičius <mmartynas@gmail.com>
2010/3/23 Piotr Przybylski <piotr.prz@gmail.com>
2010/3/23 Marc Delisle <marc@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Dne Wed, 24 Mar 2010 00:04:54 +0100 Martynas Mickevičius <mmartynas@gmail.com> napsal(a):
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.
Bellow SQL edit textarea you can enter name of query to bookmark it.
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.
Adding more choices does not always improve usability. In fact it usually works exactly opposite way. Slightly off topic, but good reasoning for actually giving less choices: http://www.ted.com/talks/lang/eng/barry_schwartz_on_the_paradox_of_choice.ht...
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.
You can also translate online: https://l10n.cihar.com/ -- Michal Čihař | http://cihar.com | http://blog.cihar.com
On 29 March 2010 16:27, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Wed, 24 Mar 2010 00:04:54 +0100 Martynas Mickevičius <mmartynas@gmail.com> napsal(a):
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.
Bellow SQL edit textarea you can enter name of query to bookmark it.
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.
Adding more choices does not always improve usability. In fact it usually works exactly opposite way.
Slightly off topic, but good reasoning for actually giving less choices:
http://www.ted.com/talks/lang/eng/barry_schwartz_on_the_paradox_of_choice.ht...
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.
You can also translate online: https://l10n.cihar.com/
--
I have written my proposal according to the discussion we had in this thread. If you want to check it out, you can find it here: http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en where you can comment any points worth doing that. If the editable version gets corrupted very much you can always find PDF version here: http://www.2m.lt/files/GSoC_2010_phpMyAdmin.pdf I would greatly appreciate any comments. However I will be unable to respond until the end of this week since I will be out for the Easter break.
Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Martynas Mickevičius a écrit :
I have written my proposal according to the discussion we had in this thread. If you want to check it out, you can find it here:
http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en <http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en>
where you can comment any points worth doing that. If the editable version gets corrupted very much you can always find PDF version here:
http://www.2m.lt/files/GSoC_2010_phpMyAdmin.pdf
I would greatly appreciate any comments. However I will be unable to respond until the end of this week since I will be out for the Easter break.
Martynas, You should not send your proposals to these places. The only proper place to send your proposal in on the official interface at http://socghop.appspot.com/ Please send it there and remove it from the other places. -- Marc Delisle http://infomarc.info
On 31 March 2010 14:17, Marc Delisle <marc@infomarc.info> wrote:
Martynas Mickevičius a écrit :
I have written my proposal according to the discussion we had in this thread. If you want to check it out, you can find it here:
http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en
< http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en
where you can comment any points worth doing that. If the editable version gets corrupted very much you can always find PDF version here:
http://www.2m.lt/files/GSoC_2010_phpMyAdmin.pdf
I would greatly appreciate any comments. However I will be unable to respond until the end of this week since I will be out for the Easter break.
Martynas, You should not send your proposals to these places. The only proper place to send your proposal in on the official interface at http://socghop.appspot.com/
Please send it there and remove it from the other places.
Hm. Ok. I removed my application from the mentioned links. I will add my application to gsoc site. I mentioned in the "Student application : no rush please" thread that I am going to attach my application links to this thread and I got no negative response so I thought it was OK to do it. Sorry for the fuss. (:
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Martynas Mickevičius a écrit :
On 31 March 2010 14:17, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote:
Martynas Mickevičius a écrit :
> I have written my proposal according to the discussion we had in this > thread. If you want to check it out, you can find it here: > > http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en <http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en> > <http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en <http://docs.google.com/Doc?docid=0AcmR3UsXFvy-ZHJ3aG1tc18zZzVodmtuZHM&hl=en>> > > where you can comment any points worth doing that. If the editable > version gets corrupted very much you can always find PDF version here: > > http://www.2m.lt/files/GSoC_2010_phpMyAdmin.pdf > > I would greatly appreciate any comments. However I will be unable to > respond until the end of this week since I will be out for the Easter break.
Martynas, You should not send your proposals to these places. The only proper place to send your proposal in on the official interface at http://socghop.appspot.com/
Please send it there and remove it from the other places.
Hm. Ok. I removed my application from the mentioned links. I will add my application to gsoc site.
I mentioned in the "Student application : no rush please" thread that I am going to attach my application links to this thread and I got no negative response so I thought it was OK to do it. Sorry for the fuss. (:
Sorry, due to the huge number of active threads in this list, I don't have the time to react correctly to all of them... -- Marc Delisle http://infomarc.info
participants (4)
-
Marc Delisle -
Martynas Mickevičius -
Michal Čihař -
Piotr Przybylski