April 2013 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp
by Kasun Chathuranga 12 May '13

12 May '13

Hi all, I am interested in the feature request #1397 [1], which requests that phpMyAdmin support fractional seconds in time, datetime and timestamp data types. After bit of research I found that these data types support trailing fractional seconds up to microseconds (6 digits). For example, the syntax for datetime including fractional seconds would be '2013-04-23 11:21:07.145236'. This syntax is supported from version 5.0 [2], however the fractional seconds were discarded when storing. From version 5.6.4 onwards these fractional seconds are stored and hence this feature request is important. I have looked into the code to implement this feature request and the major problem faced is the incompatibility of JavaScript timepicker used [4], which only supports up to milliseconds (3 digits). I have been improving this JS file to support microseconds, however it is a somewhat big change. I'd like to know whether I should simply alter the external JS file in phpMyAdmin code or I should send a pull request to the timepicker project, so it will be a part of the timepicker project as well. However, with the second option it might take some time till they (hopefully) accept the patch and do a release containing it. Your thoughts on this would be highly appreciated. [1] https://sourceforge.net/p/phpmyadmin/feature-requests/1397/ [2] https://dev.mysql.com/doc/refman/5.0/en/datetime.html [3] https://dev.mysql.com/doc/refman/5.6/en/datetime.html [4] http://trentrichardson.com/examples/timepicker/ -- Regards Kasun Chathuranga

2 5

[Phpmyadmin-devel] Usability of designer without configuring the phpMyAdmin configuration storage
by Shamika Dharmasiri 02 May '13

02 May '13

Hi All, As describes [0] we can configure to use advanced features in PMA including designer feature.I have submited my proposal for this GSOC with the project [1]. There I need to give the user to use this designer functionality without configuring PMA configuration storage like [0].I have some suggestions for this.I would like to ask about the ideas to achieve this task to further improve my proposal. Thank you. [0]http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-… [1]http://wiki.phpmyadmin.net/pma/GSoC_2013_Ideas_List#Refactoring:_Designer… Shamika Dharmasiri Faculty of Engineering University Of Peradeniya

2 1

[Phpmyadmin-devel] Unit test failed. Need some guidance to solve it.
by ayush choubey 01 May '13

01 May '13

Hello, I prepared this patch https://github.com/phpmyadmin/phpmyadmin/pull/290 with the JS fix(that i applied for Firefox) it works correctly both in Firefox and chrome. Updation and insertion both work fine. But for an unknown reason it fails one of the tests. It says "Failed asserting that two arrays are equal" . I don't get it, just added an extra string in that array of functions(Types.class.php). It seems to me that the old array was expected but since i changed it, its creating some kind of problem. I don't know, i never had such situation, so i'm pretty helpless in this case. I'd be grateful, if i can have some points or hints on how to correct it. Thanks Ayush.

4 3

[Phpmyadmin-devel] GSoC question
by Mohamed Ashraf 01 May '13

01 May '13

Hello my name is Mohamed Ashraf I am a prospective GSOC applicant. I have been sending emails to the mailing list for some time now but due to complications in my subscription in the mailing list it was not being received. Sorry if this is a bit late. I was reading your Ideas list and saw the refactoring of the sql executor. I wanted to ask what is your final vision for it. what do you feel as the best design. Also if there are any bugs or features related to the executor that I could submit with my proposal. I have already done two pull requests, a feature and a bug, but I believe it would have been better if the patch was more related to my proposal

2 3

[Phpmyadmin-devel] GSoC Proposal
by Abhishek Kandoi 29 Apr '13

29 Apr '13

Hi, I have submitted my GSoC proposal for Ajax Error Reporting. It would be great if my proposal could be reviewed. Waiting for your valuable comments. -- Abhishek Kandoi First Year, Computer Science and Engineering Indian Institute of Technology Roorkee About Me : about.me/kandoiabhi

1 0

Re: [Phpmyadmin-devel] Phpmyadmin-devel Digest, Vol 81, Issue 40
by ayush choubey 29 Apr '13

29 Apr '13

Two ideas mean a lot of more works. > I think focus is important. thanks > just my mind, I also a gsoc student > > > > > > adam > > > Hi adam, yeah, i understood it, the time i began thinking about the approach that both would require and believe me the two are totally different. But till the end i couldn't make my mind on which one to select and thus wrote for both of them(Well it took me about 7 days to write about them). However in the end, i believe that mentors will select the best one. i am waiting for their comments (fingers crossed :D). And Good luck for GSoC :) Ayush

1 0

[Phpmyadmin-devel] phpMyAdmin is Application of the Year 2013
by Marc Delisle 29 Apr '13

29 Apr '13

Hi, I represented the phpMyAdmin project at the Percona Live 2013 (MySQL conference and Expo). phpMyAdmin won one of the two MySQL Community Awards: Application of the Year 2013. Details at http://openlife.cc/blogs/2013/april/mysql-community-awards-2013-and-winners… I'll add pictures on our Awards page later. -- Marc Delisle http://infomarc.info

4 3

[Phpmyadmin-devel] GSoC Proposal Advice
by Ayush Chaudhary 29 Apr '13

29 Apr '13

Hi, As I am looking to apply for the Automated Testing project this year, I was trying to make a first draft of my proposal here. I had a few questions regarding the same: 1. What aspects of automation and CI would be involved as most of the automated scripts seem to have been done already. Sure, along the way if we feel the need for modifying or adding something, that would be fine. But just wanted to make sure if there are any specific tasks involved here which I could mention in my proposal? 2. Regarding the project schedule, I was wondering if pin-pointing a specific code coverage percentage is a good idea? The aim would surely would be to maximise the code coverage, but the nature of this project is such that a pre determined percentage could be far from accurate in the final deliverables. That said, if there is a specific code coverage level the team would like to be reached, I would like to know. Right now, the two major tasks that the project seems to involve are: 1. Adding more unit tests 2. Adding more selenium tests Let me know if I am missing something here Thanks! -- Ayush Chaudhary

3 6

[Phpmyadmin-devel] phpMyAdmin 4.0.0-rc4 is released
by Marc Delisle 29 Apr '13

29 Apr '13

Welcome to the fourth release candidate for phpMyAdmin 4.0.0 (a database export bug was introduced in -rc3). With this version, the HTML frames are gone and the navigation panel now presents a tree. This version requires Javascript. Version 4.0 contains many bug fixes and smaller new features; moreover, the documentation has a new look and contains an index. Details will appear on http://phpmyadmin.net. In a hurry? you can visit https://sourceforge.net/projects/phpmyadmin/files to download. Marc Delisle, for the team

2 1

[Phpmyadmin-devel] GSoC Propsal
by ayush choubey 29 Apr '13

29 Apr '13

Hi, Today, i submitted my GSoC applications. I was equally interested in both Interface improvement and Ajax Error Reporting, but till the end, i couldn't make up my mind for just one, So i submitted proposals for both and left the rest on mentors to decide. I would be grateful, if i my proposal can be reviewed and have some valuable comments. Regards Ayush Choubey

2 1