February 2012 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Single point for developers
by Michal Čihař 13 Feb '12

13 Feb '12

Hi all currently our documentation for upcoming developers is spread over different places: [1] FAQ 7.3 in Documentation [2] Developers section in Documentation [3] http://www.phpmyadmin.net/home_page/devel.php [4] wiki What I'd like to do is to move most information to website [3], with possible more detailed information on wiki [4] and removing almost all content from Documentation [1],[2]. Currently it is quite hard to keep the information up to date [*] and I don't think it makes much sense to provide information in the documentation for offline usage as you would anyway require to be online to contribute. I've just submitted pull request for this change on github, so feel free to comment it there: https://github.com/phpmyadmin/phpmyadmin/pull/1 [*]: I think that [2] will become really outdated on our way to 4.0. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 3

[Phpmyadmin-devel] removal of BLOBstreaming support
by Marc Delisle 13 Feb '12

13 Feb '12

Hi, I am volunteer to remove, from the master branch, support for this feature which does not seem to be popular in the community. Any objection? -- Marc Delisle http://infomarc.info

4 4

[Phpmyadmin-devel] GSoC 2012 and removal of frames?
by Marc Delisle 13 Feb '12

13 Feb '12

Hi, I believe that at the meeting, there were objections to put this in the ideas list, am I right? -- Marc Delisle http://infomarc.info

5 5

[Phpmyadmin-devel] INSTALL.txt better than INSTALL ?
by Marc Delisle 13 Feb '12

13 Feb '12

Hi, Is it some kind of standard to have an INSTALL file? Renaming it to INSTALL.txt would avoid problems like the one in [0]. [0] https://sourceforge.net/projects/phpmyadmin/forums/forum/72909/topic/5011405 -- Marc Delisle http://infomarc.info

7 8

[Phpmyadmin-devel] GSoC 2012 timeline
by Marc Delisle 13 Feb '12

13 Feb '12

Hi, as a reminder, the timeline is located at [0]. Mentoring organizations can submit their application from February 27 to March 9. [0] http://www.google-melange.com/gsoc/events/google/gsoc2012 -- Marc Delisle http://infomarc.info

2 4

[Phpmyadmin-devel] Roadmap to phpMyAdmin 4.0
by Marc Delisle 10 Feb '12

10 Feb '12

Hi, During the recent team meeting (February 5, 2012), we discussed about the long term development effort for the phpMyAdmin project. Here are the conclusions. Removal of frames Frames won't be used anymore (they separated the navigation panel from the main panel). Instead, a single page will be presented, with various parts dynamically reloaded with AJAX. This will require JavaScript to be enabled in the browser. Code base refactoring The code base will be cleaned up using refactoring. The goal is to remove the mix of HTML and PHP and produce code easier to maintain. Some parts will move to OOP, but we decided against switching to a framework. New features We currently do not plan any major new functionality for this version. Browser requirement Looking back, version number was bumped to 3.0 when new system requirements (PHP 5.2, MySQL 5.0) were introduced. Therefore, version number will go to 4.0 to accentuate the new browser requirement of having JavaScript active. The team

1 0

[Phpmyadmin-devel] Fighting spam on the wiki
by Michal Čihař 09 Feb '12

09 Feb '12

Hi all as next step in anti spam battle on our wiki, I've decided to require confirmed email address before people can edit anything. See mediawiki docs for more info: http://www.mediawiki.org/wiki/Manual:$wgEmailConfirmToEdit -- Michal Čihař | http://cihar.com | http://blog.cihar.com

1 0

[Phpmyadmin-devel] Using Case or If statement
by Rick Beach 08 Feb '12

08 Feb '12

When creating a view in phpmyadmin on yahoo business I need to know the corrct syntax to return text. Below are two examples of an If statement and a case statement that return an Integer. Both of these views work correctly. There are also three examples of an If statement to return text and three examples of case statements to return text. None of these six examples work correctly even when using using single quotes, double qoutes or no quotes at all. Please review all of the below examples and let me know what is happening that the select statement changes. SELECT If(Month(Now())=2,555,999) works correctly SELECT case Month(now()) when 2 then 555 else 999 end works correctly SELECT If(Month(Now())=2,'Feb','Oth') changes the select statement to: SELECT If(Month(Now())=2,\'Feb\',\'Oth\') and gives error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Feb\',\'Oth\')' at line 5 SELECT If(Month(Now())=2,"Feb","Oth") changes the select statement to: SELECT If(Month(Now())=2,\"Feb\",\"Oth\") and gives error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"Feb\",\"Oth\")' at line 5 SELECT If(Month(Now())=2,Feb,Oth) gives below error: #1054 - Unknown column 'Feb' in 'field list' SELECT case Month(now()) when 2 then 'Feb' else 'Other' end changes the select statement to: SELECT case Month(now()) when 2 then \'Feb\' else \'Other\' end and gives error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Feb\' else \'Other\' end' at line 5 SELECT case Month(now()) when 2 then "Feb" else "Other" end changes the select statement to: SELECT case Month(now()) when 2 then \"Feb\" else \"Other\" end and gives below error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"Feb\" else \"Other\" end' at line 5 SELECT case Month(now()) when 2 then Feb else Other end gives below error: #1054 - Unknown column 'Feb' in 'field list'

2 1

[Phpmyadmin-devel] github outage
by Marc Delisle 08 Feb '12

08 Feb '12

Hi, github.com currently has network connectivity issues, see http://twitter.com/github -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] Doing changes in multiple branches
by Michal Čihař 08 Feb '12

08 Feb '12

Hi all several times, I've noticed some of you make same changes in all branches. The preferred way (so that we have only one commit in history doing the change) is to make change first in most specific/oldest branch and then merge it to others. This is also explained on our wiki: http://wiki.phpmyadmin.net/pma/Git#Committing_fixes_to_several_branches -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

1 0