April 2009 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Zeeshan Mughal; GSoC student
by Zeeshan Mughal 18 May '09

18 May '09

Hello, phpMyAdmin developers! I am Zeeshan Mughal, a student at Stony Brook University studying Computer Engineering. First off, I would like to thank you phpMyAdmin team for accepting my proposal. I hope this summer of code will bring me closer to free software development, and I will become more enthusiastic about it in the coming future. Basically, my project is not very nifty as other projects. I plan to write a library that will enable users to store their preferences permanently. So, if a user wants to view 100 entries per table each time he/she accesses the system, this script will make it happen. Well, this would not be the only user preference to be stored permanently. There are of course other preferences that user wants to store permanently. I would appreciate if you can share with me your ideas about what other settings may be suited to be stored permanently. Please check out my newly-created Joomla! powered web log at: http://www.zeeshan.zixan.net Thank you! -------------------------------------------------- Best regards, Zeeshan Mughal Telephone: +1 347 284 8987 Email: zeeshanmughal(a)ieee.org Web: http://zeeshan.zixan.net

3 2

[Phpmyadmin-devel] Planet phpMyAdmin
by Michal Čihař 29 Apr '09

29 Apr '09

Hi all now when there is already some content, it's time to announce planet phpMyAdmin. You will find there posts from phpMyAdmin contributors including Google Summer of Code students, so you might find there what interesting ideas they have. Please note that this blog does not have to contain only phpMyAdmin related posts, it's just for all what contributors do (as usual on other planets). It currently lives on <http://pmaplanet.cihar.com/>. PS: If you think your blog is missing there, please drop me a note. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

2 2

[Phpmyadmin-devel] phpMyAdmin 3.1.4 is released
by Marc Delisle 25 Apr '09

25 Apr '09

Welcome to phpMyAdmin 3.1.4, a bugfix version. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team

1 0

[Phpmyadmin-devel] Planet phpMyAdmin
by Michal Čihař 22 Apr '09

22 Apr '09

Hello all I'd like to announce start of Planet phpMyAdmin. Currently it lives on http://pmaplanet.cihar.com/, but I hope it will get official phpmyamin.net domain soon (hi Olivier ;-)). All blogs of people contributing to phpMyAdmin in any way can be included there, just drop me a note. For now it includes GSoC students and mine blog. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

1 0

[Phpmyadmin-devel] GSoC Introduction
by Derek Schaefer 22 Apr '09

22 Apr '09

Greetings fellow phpMyAdmin developers! My name is Derek Schaefer, and I will be improving the import system for my GSoC project. This includes import plug-ins for Open Document Spreadsheet, CSV (the existing one is to be extended), XML, and ideally other formats as well. At the core of all this is a powerful extension to the current import system; an intelligent table creation interface that will be capable of detecting column types, recommending various important settings, but most importantly, allowing the user to view and alter the table schema before committing. This will be especially useful for loosely-typed formats such as CSV, ODS, and PMA's current XML schema, among others. The blog to which I will be posting updates is located here: http://www.moonlapse.org/ Over the next couple days I will be adding all the information regarding my project to the above blog for your viewing pleasure, so stay tuned! I look forward to working with all of your over the coming months. Take care everyone, -Derek Schaefer

1 0

[Phpmyadmin-devel] Introduction
by Tomas Srnka 22 Apr '09

22 Apr '09

Hi, I'm Tomas Srnka, 18 years old and living in Slovakia. In next two months, I will finish my high school (IBD programme). I'm applying to Google Summer of Code 2009 for implementation of replication into phpMyAdmin. Therefore, I have started studying phpMyAdmin code by adding small new features. This morning, I finished table, which displays information about master status in "Server Status" section (see http://toms.linuxos.sk/gsoc09/phpMyAdmin/ for screenshots). I'm sending two patches, which bring the feature. Any comments are more than welcomed :). My plan is to create section with information about both master and slave statuses at the beginning. Best Regards, Tomas Srnka *** phpMyAdmin-dev-svn/phpMyAdmin-dev/lang/english-utf-8.inc.php 2009-04-05 11:45:16.000000000 +0200 --- phpMyAdmin-dev/lang/english-utf-8.inc.php 2009-04-05 12:10:27.000000000 +0200 *************** *** 718,723 **** --- 718,726 ---- $strReplaceNULLBy = 'Replace NULL by'; $strReplaceTable = 'Replace table data with file'; $strReplication = 'Replication'; + $strReplicationStatus = 'Replication Status'; + $strReplicationMasterStatus = 'Master Status'; + $strReplicationMasterStatusNotAvailable = 'This server does not work as master server.'; $strReset = 'Reset'; $strResourceLimits = 'Resource limits'; $strRestartInsertion = 'Restart insertion with %s rows'; *** phpMyAdmin-dev-svn/phpMyAdmin-dev/server_status.php 2009-04-05 11:45:41.000000000 +0200 --- phpMyAdmin-dev/server_status.php 2009-04-05 13:05:26.000000000 +0200 *************** *** 64,76 **** */ $server_status = PMA_DBI_fetch_result('SHOW GLOBAL STATUS', 0, 1); /** * for some calculations we require also some server settings */ $server_variables = PMA_DBI_fetch_result('SHOW GLOBAL VARIABLES', 0, 1); - /** * starttime calculation */ --- 64,80 ---- */ $server_status = PMA_DBI_fetch_result('SHOW GLOBAL STATUS', 0, 1); + /** + * get master status from server + */ + $server_master_status = PMA_DBI_fetch_result('SHOW MASTER STATUS'); + /** * for some calculations we require also some server settings */ $server_variables = PMA_DBI_fetch_result('SHOW GLOBAL VARIABLES', 0, 1); /** * starttime calculation */ *************** *** 460,465 **** --- 464,524 ---- <hr class="clearfloat" /> + <h3><?php echo $strReplicationStatus ?></h3> + <h4><?php echo $strReplicationMasterStatus ?></h4> + <?php + if (count($server_master_status)==0) + echo $strReplicationMasterStatusNotAvailable."<br />\n"; + else { + ?> + <table id="serverstatusqueriessummary" class="data"> + + <thead> + <tr> + <th><?php echo $strVar;; ?></th> + <th><?php echo $strValue; ?></th> + </tr> + </thead> + <tbody> + <tr class="odd"> + <td class="name"> + File + </td> + <td class="value"> + <?php echo $server_master_status[0]["File"]; ?> + </td> + </tr> + <tr class="even"> + <td class="name"> + Position + </td> + <td class="value"> + <?php echo $server_master_status[0]["Position"]; ?> + </td> + </tr> + <tr class="odd"> + <td class="name"> + Binlog_Do_DB + </td> + <td class="value"> + <?php echo $server_master_status[0]["Binlog_Do_DB"]; ?> + </td> + </tr> + <tr class="even"> + <td class="name"> + Binlog_Ignore_DB + </td> + <td class="value"> + <?php echo $server_master_status[0]["Binlog_Ignore_DB"]; ?> + </td> + </tr> + </tbody> + </table> + <?php + } + ?> + <hr class="clearfloat" /> + <h3><?php echo sprintf($strQueryStatistics, PMA_formatNumber($server_status['Questions'], 0)); ?></h3> *************** *** 674,679 **** --- 733,739 ---- ?> </div> </div> + <?php

3 4

[Phpmyadmin-devel] phpMyAdmin 3.1.4-rc2 is released
by Marc Delisle 17 Apr '09

17 Apr '09

Welcome to the second release candidate for phpMyAdmin 3.1.4, a bugfix version. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team

1 0

[Phpmyadmin-devel] Blog anyone?
by Michal Čihař 15 Apr '09

15 Apr '09

Hi all as we're going to push Google Summer of Code students to publish their status regularly in blogs, I decided that it might be good idea to setup Planet [1] aggregator for these blogs. When doing this, it is obvious that developer blogs should be also included. Does anybody of you have a blog which should be included? The posts don't have to be phpMyAdmin related, it's mostly about knowing what all do others do, but the posts should be in English. [1]: http://www.planetplanet.org/ -- Michal Čihař | http://cihar.com | http://blog.cihar.com

1 0

[Phpmyadmin-devel] phpMyAdmin 3.1.4-rc1 is released
by Marc Delisle 14 Apr '09

14 Apr '09

Welcome to the first release candidate for phpMyAdmin 3.1.4, a bugfix-only version. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team

1 0

[Phpmyadmin-devel] phpMyAdmin 3.1.3.2 is released
by Marc Delisle 14 Apr '09

14 Apr '09

Welcome to phpMyAdmin 3.1.3.2, a security-fix version. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team

1 0