March 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] PMA UI Idea
by Vipin Nair 22 Mar '10

22 Mar '10

Hello everyone, I am back with my small crazy Idea! I think a Drag-n-Drop database creation feature(Something Similar to MySql Workbench) would be a very good idea implement as a part of new UI. PMA could be next Workbench Killer, if implemented properly. I tried to implement drag-n-drop using JqueryUI and did get some initial success. Since PMA is going to get a facelift, i think this feature is a must. Right now, my code can add a database and a table to the database using drag-n-drop (Not using PMA). There are a few UI bugs, removing which i'll upload the code. I do hope my idea gets implemented as it'll be a revolutionary change in the way a database is created using PMA. Thank You, Vipin Nair nair.vipin(a)ymail.com swvist(a)gmail.com

2 1

[Phpmyadmin-devel] GSoC 2010
by AKASH NAWANI 22 Mar '10

22 Mar '10

hi I am Akash Nawani, student of Computer Science and Engineering from Institute of Technology, BHU, India. I want to contribute to phpMyAdmin as a GSoC 2010 student. I am interested in doing project named "Charts in server status page". I have been using phpMyAdmin since last 2 years and have a good knowledge of PHP and MySQL. I have also used GD2 for drawing graphs. I would like to hear your opinions about this project so that I can start with it. Regards, Akash

2 1

[Phpmyadmin-devel] posting style on this list
by Marc Delisle 22 Mar '10

22 Mar '10

Hi, I suggest we all use bottom-posting on this list. It makes the flow of questions/answers more easy to follow. http://en.wikipedia.org/wiki/Top-posting#Bottom-posting -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Information regarding the GSoC project Idea [ Exporting relations schema to other formats]
by Bageshwar Pratap Narain 21 Mar '10

21 Mar '10

I need some guidance as to, what should be the roadmap to participate in this project.

2 3

[Phpmyadmin-devel] Idea for Google Summer of Code - Cleaning up phpMyAdmin interface
by Ramindu Deshapriya 20 Mar '10

20 Mar '10

Hi, I am a student at the University of Moratuwa, Sri Lanka and I have 2 years experience working with PHP and MySQL. During this time I have made use of phpMyAdmin during all my projects involving MySQL and database management, therefore I would like to give something back to phpMyAdmin in the form of a GSoC Project. The project idea that interested me the most was 'cleaning up the interface' idea. I went through the feature requests that have been posted with regard to this idea, and I think I could manage to provide these requirements. It would also be interesting if I could collaborate with whoever is taking the 'AJAX for the interface' project and complete both projects as a combined effort. e.g. A feature that could be provided on the interface via AJAX could be, when the mouseover event is triggered on a specific database's name, a drop down Javascript list could be generated which would allow the user to select a specific table for viewing. Hope to hear your feedback on this. Thank You! -- Yours Truly, Ramindu Deshapriya.

2 1

[Phpmyadmin-devel] Project suggestion - AJAX Improvement in GUI - Google SoC
by Meher Anand 20 Mar '10

20 Mar '10

Hi all. I came across the project idea of improving the UI of phpMyAdmin. As a user, I wanted a lot of improvement myself since I deal with large databases and the current UI slows down my work by a great deal. I have been using JQuery for more than a year now and I've become pretty good at it. I was wondering if one could use JQuery entirely for to make the front end resemble MySQL Query Browser, an application that I use a lot for my database work when there are no 3306 firewalling issues. Please do let me know if I can proceed with this idea for my Google SoC application. Regards. Meher Anand 4th Year Department of Computer Science & Engg. Visvesvaraya National Institute of Technology Nagpur, India

2 3

[Phpmyadmin-devel] Introduce myself
by Lee Sing Jie 20 Mar '10

20 Mar '10

Hi, I am Lee Sing Jie from National University of Singapore, doing Computer Engineering. As the term engineering derives, I have experience in both software and hardware coding. In school, I have done assembly language, C, C++ etc. Out of school, I offer freelance web eCommerce solutions. I have setup multiple online shops for new businesses, so PMA is of no stranger to me. Many of the old catalogs system I implemented are fully coded by me. During this GSOC, I am interested in contributing to PMA by developing Charts in server status page. Shortly, I will try to pick up some of the bugs in the tracker and try to merge myself into this PMA development sting. I hope I can do my part to the open source community and of course to PMA. Regards, Sing Jie

2 1

[Phpmyadmin-devel] Introduction
by Himanshu Bansal 20 Mar '10

20 Mar '10

Hi I want to complete PMA User interface cleanup project for GSoC 2010. I am working on the implementation part of it and will surely brief the concerned persons about it soon. For now, I just had a doubt that if I can co-ordinate with the OOP PMA project people, that would make the new PMA far more better according to my approach, please let me know if that is possible. Himanshu Bansal Sophomore BITS Pilani Goa Campus

2 2

[Phpmyadmin-devel] GSoC 2010 (User interface cleanup)
by Sumesh KS 19 Mar '10

19 Mar '10

Hi Everyone! I am Sumesh ks, From India. I am currently pursuing Master of Computer Application at Govt. Engineering College (RIT), Mahathama Gandhi University, Kerala. I have been programming and developing applications for about 2 years, and programming has always been a passion. I love a mix of large projects and programming contests to keep the adrenaline running! I haven't contributed to any opensource project, But have developed web based or desktop applications for internal purposes at my college or for hobby. Have worked on windows and linux platforms, languages and strong in software design and quick implementation. I have good knowledge in C,C++,PHP,MySQL.and also have good experience in Adobe Photoshop,Flash, Iam using phpmyadmin for 2 years for my web development projects. I read your ideas for Google Summer of code 2010. i am interested in working "User interface cleanup". I read the feature request mentioned in the idea list and i like to work on that.Feature requests: rfe:1714760, rfe:2649375, rfe:1494550, rfe:735925. Thanks and regards, Sumesh ks.

2 1

[Phpmyadmin-devel] [GSoC] OO PMA project proposals
by Edouard SWIAC 19 Mar '10

19 Mar '10

Hello, It's a great thing that phpMyAdmin is part of the GSoC this year! I presented myself some weeks ago, then discussed with Marc about some ideas on this project. Now I'm submitting these to all the developers. Ideas on some this project - Separating the presentation tier from the logic tier (currently in discussion on the devel mailing list). Moreover, no presentation layer should be present in the libraries' modules. All presentation related files (header_*.inc.php and footer.inc.php) would leave the /libraries dir. - In the PMA library, OO written modules could be loaded using PHP's autoloading capacities. Folders should be used to help organize the librairies folder, to restrict the number of files directly within /librairies and enforce modularity in the library structure. - Every file that's present two or three times and more with the same namespace (server_*, select_*, tbl_*, pmd_* ...), both from / and /librairies could be grouped and namespaced in one or more static methods, to benefit from autoloading, decreasing the amount of file and the require/include to write. Files used directly in the presentation layer (as server_* in /), once class transformed, would be queried from the logic tier for the presentation tier, should a template system be adopted. - All export and import related files (/libraries/export/* and /libraries/import/*)could be merged in an Export and an Import modules. These modules would offer a uniform interface to ensure that third parties and vendors file format implements the methods PMA needs to interact with to send and retrieve data, and are object oriented. This could simplify the addition of new export/import format by third parties/companies. Moreover, third parties libraries (such as tcpdf or PHPExcel) should be located within their related module directory and not directly under /libraries. Before that, existings export/import libs have to be rewritten in OOP to be compliant with their own module interface. - Libs like common.lib.php have too much and various responsibilities (and responsibilities from other layers). Without stepping directly into OO code, these files could be breaked in more specifics libs. Obviously, a 'common' named file contains common functions, but I think it's too much functions in a single file. For exemple, common.lib.php = 2771 lines. math functions, mysql functions, 'templating' function, escaping functions, formatting functions, navigation functions, messaging function (PMA_showMessage has ~260 lines, big for a single function, too many responsibilities), date functions, pagination, cache management (that one could get its own class). - Global vars and objects access. Sometimes 'global' keyword is used between related functions, most of the time it's $_GLOBALS, and I could bet that I saw a Registry somewhere, but can't get my hands on anymore. What are the rules you observe concerning the global namespace ? $_GLOBALS for now and Registry for later ? I also checked the Feature Request on the tracker, but most of the suggested features are not "OO code" oriented. I am open to discussion on every ideas above, and even more ! Regards, Edouard

2 1