March 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] GSoC - AJAXify the Interface for phpMyAdmin
by Ninad Pundalik 25 Mar '10

25 Mar '10

Hi All, After reading through the GSoC Ideas wiki page[0] and the discussion on the feature request[1] of adding AJAX functionality to phpMyAdmin, I could think up of a possible implementation as follows, other than the one already outlined very briefly on the discussion page (of starting out with the Query page, implementing the common jQuery and PHP functions and then replicating the process for the other action pages) : 1. Implement this as an add-on in the initial phase. Replicate all the PHP files which operate on the database in a folder, '/ajax/' making them AJAX endpoints. 2. Modify the PHP code in each of the endpoints, so that we can output the content in XML, JSON or plain HTML (whichever is decided to be used). 3. On each action page, add some PHP code, which checks for a cookie/database setting and confirms that the client supports JavaScript. In the if block, add jQuery/MooTools code which will manipulate the necessary links and forms on the page, carry out the actual AJAX calls, and also implement callback functions, which will handle the responses from the AJAX endpoints. 4. In case the client does not support JavaScript, the code inside the if block will not be executed, and the existing PHP code of the page will handle the noscript case. Due to the above steps, we can maintain backward compatibility with browsers that do not support/have disabled JavaScript. Also, by implementing this as an add-on where the AJAX endpoints are maintained separately, we can ensure that the existing code is modified to the least possible extent and all changes that occur, are localized in the /ajax/ folder. I agree that this will lead to increased work in maintaining the common code for some months, but it gives me freedom to play and implement this functionality without breaking the core code. Once the modifications are deemed stable enough, the changes could be merged into the core code. Also, a quick look through the /js/ folder shows that the Designer interface already uses MooTools, as is mentioned in the feature request discussion. However, a previous mail on this list by Marc says that jQuery will be used for this project. I'd like to know if I'm thinking in the right direction. If I am, I will prepare this idea more thoroughly, it's deliverables, with the proper timeline requirements, as well as work on some patches, as is required in the Student Checklist[2]. :) My name is Ninad Pundalik, and I'm a student at the Birla Institute of Technology and Science, Pilani, India, and I wish to apply for the Google Summer of Code project with phpMyAdmin. I have been writing small websites in PHP, MySQL and jQuery for some student activities on campus, and have completed an internship last summer, where I helped in implementing Google Calendar APIs and Google and Twitter OAuth. As a result, I have been regularly using PMA for close to two years. While looking through the ideas for GSoC, I scanned the PMA code, and found it very easy to understand and of course, well commented and logically designed. Hence, I hope to get a chance to give back to this excellent software. Waiting for a reply, so that I could further develop this idea and prepare my application in time. :) ------------------- [0] - http://wiki.phpmyadmin.net/pma/GSoC_2010_Ideas_List [1] - http://sourceforge.net/tracker/index.php?func=detail&aid=2131880&group_id=2… [2] - http://wiki.phpmyadmin.net/pma/GSoC_2010_Student_Checklist ------------------- Ninad S. Pundalik http://twitter.com/ni_nad http://ninadpundalik.co.cc/blog GPG Key Fingerprint: 2DF7 B856 C75E C9F9 0504 C0EF D456 1946 7C45 2C69

3 3

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

25 Mar '10

Thanks for your observations Marc. > About PDO, the last time I had a look at it, there were no practical > reasons to support it. I think there is at least one major reason to support it (PHP version independently). Since PMA accepts two data access interface ,mysql_* and mysqli_*, using PDO would avoid maintaining these 2 interfaces in adapters functions (such as PMA_DBI_fetch_row ...). Moreover, mysql_* and mysqli_* API are so nearly identical, that almost the same code is written twice. As you know PDO handles these two drivers natively, lowering the burden of code to write and maintain. Coming back to architecture, templating (currently is active discussion) is a good way to go towards MVC. What do you think about it ? From what I see in PMA source code, some parts are developed with classes (Confirm, Error, File ...), so the project may consists in pursuing this objective, in order to smoothly convert the procedural code base into an oriented one. Regards, Edouard

4 8

[Phpmyadmin-devel] To potential GSoC students
by Marc Delisle 25 Mar '10

25 Mar '10

We appreciate the interest of students to take part in this year's Google Summer of Code with phpMyAdmin. Unfortunately our mentor manpower is limited. Because of this please take care when filling your proposal and follow our student checklist on the wiki. This way you can dramatically increase your chance of being accepted. We will especially take into account your code contributions to phpMyAdmin so far. - the mentors

1 0

[Phpmyadmin-devel] Rasmus' no-framework MVC article
by Marc Delisle 25 Mar '10

25 Mar '10

Hi, for those who are not aware, Rasmus Lerdorf has an interesting article: http://toys.lerdorf.com/archives/38-The-no-framework-PHP-MVC-framework.html I need to study it more, however I believe that we should take these ideas into account while discussing any MVC move for phpMyAdmin. -- Marc Delisle http://infomarc.info

3 4

[Phpmyadmin-devel] PMA Redesign - GSoC
by Thomas de Lima 25 Mar '10

25 Mar '10

Hi! My name is Thomas de Lima. I'm a computer engineering student from Brazil. I want to discuss more the idea of redesigning PMA, because I want to be sure I understood it correctly. Design is not only about changing color or shapes in the user interface, but also about changing how the user interacts with the application, towards improving usability. So, the "User interface cleanup" project needs to be codeveloped with the AJAX team. Is that right? I read an email from our indian colleague Anirvana Mishra, excited about ajaxifying PMA. But then Michal answered that he should pick one specific area to improve, cause there's too much functionality in PMA. Well, as a database manager, the PMA should be lightweight and "usable". For example, it takes a great deal of HTML download and clicks to find and edit someone's data in a huge personnel table. AJAX could solve both problems by opening a quickedit option on a browse table's row, which could be quickly found by an AJAX filter on top. So I think one of the "User interface cleanup" project goals should be study of which features need to be ajaxified or changed, or whatever, not about picking, before a deeper study, an area to improve. For this purpose I wish to apply as an GSoCer to improve the PMA user interface, cause I frequently use it to manage my databases remotely. Of course PMA's usability now is excellent, as everything is intuitively put in place, but it feels soooo Web1.0, so static. Thanks, thomas.

2 2

[Phpmyadmin-devel] Git is here
by Michal Čihař 24 Mar '10

24 Mar '10

Hi all I should have announced it earlier (as the repository migration went as planned), however I somehow got focused to migrating other tools meanwhile so the announcement comes now. So yes, everything is in Git now and the Subversion repository is in read-only mode. Please check if something is not broken, I might have missed something. Things which should work without problems: - demo server - daily snapshots - website, translation stats,... - creating releases [1] For using Git, please follow instructions in wiki [2]. Especially working properly with more branches can save you lot of work. [1]: As I added there some improvements, I also started documentation for release process (which is far from being complete right now) on wiki: http://wiki.phpmyadmin.net/pma/Devel:Releasing [2]: http://wiki.phpmyadmin.net/pma/Devel:Git -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 14

Re: [Phpmyadmin-devel] Proposal for GSOC 2010.
by Hemanth kumar 24 Mar '10

24 Mar '10

Hi, I'l submit my proposal formally on march 29. Regarding Exporting it to XML format what i intended to say was i want to exporting whole database into XML format with one click. I've an idea on how to do it. MySQL supports converting sql query result into XML and Mysql also displays complete list of tables using "show tables;" We have to merge both the features. I Dont know if its extensively useful but as an admin UI i want to provide all the features. Thanks & Regards R Hemanth Kumar Date: Tue, 23 Mar 2010 14:25:39 -0400 From: Marc Delisle <marc(a)infomarc.info> Subject: Re: [Phpmyadmin-devel] Proposal for GSOC 2010. To: phpmyadmin-devel(a)lists.sourceforge.net Message-ID: <4BA907A3.2040602(a)infomarc.info> Content-Type: text/plain; charset=UTF-8; format=flowed Hemanth kumar a ?crit : > Hi , > > I'm Hemanth,Undergrad Student of Bits-Pilani Goa campus-INDIA. I would > like to work on GSOC project USER INTERFACE CLEANUP. > > Last semester i developed an intranet application using php, Mysql, I > used phpMyAdmin for it and i feel there should be some changes in the > user interface and i would like to share my suggestions for phpMyAdmin > user interface cleanup. > > 1. User should be able to customize the user interface of phpMyAdmin. > Example: user should able to hide unwanted Links. > OR > Less used links should be under one link moving cursor upon it drops > down a menu of less used links. > > 2. GUI should be Made simpler for Novice or There should two instances > of phpMyAdmin one for Basic users and other for Advanced Users. Hi, these are interesting points that you can put in your formal proposal, when Google's interface accepts proposals on March 29. > > Recently I worked on php, XML, MySQL and i noticed phpMyAdmin doesn't > have a feature which converts result of a SQL query to XML format which > can be used for taking backup of data. In phpMyAdmin 3.3.1, in table Export you can export in XML. Did you try it? > > I would like to work on the above as GSOC 2010 project. -- Marc Delisle http://infomarc.info -- R.Hemanth Kumar Bits-pilani Goa campus Msc Economics+B.E. (hons) Chemical engineering

1 0

[Phpmyadmin-devel] Proposal for GSOC 2010.
by Hemanth kumar 23 Mar '10

23 Mar '10

Hi , I'm Hemanth,Undergrad Student of Bits-Pilani Goa campus-INDIA. I would like to work on GSOC project USER INTERFACE CLEANUP. Last semester i developed an intranet application using php, Mysql, I used phpMyAdmin for it and i feel there should be some changes in the user interface and i would like to share my suggestions for phpMyAdmin user interface cleanup. 1. User should be able to customize the user interface of phpMyAdmin. Example: user should able to hide unwanted Links. OR Less used links should be under one link moving cursor upon it drops down a menu of less used links. 2. GUI should be Made simpler for Novice or There should two instances of phpMyAdmin one for Basic users and other for Advanced Users. Recently I worked on php, XML, MySQL and i noticed phpMyAdmin doesn't have a feature which converts result of a SQL query to XML format which can be used for taking backup of data. I would like to work on the above as GSOC 2010 project. Thanks and Regards -- R.Hemanth Kumar Bits-pilani Goa campus Msc Economics+B.E. (hons) Chemical engineering

2 1

[Phpmyadmin-devel] phpMyAdmin OOP
by harsh gidra 23 Mar '10

23 Mar '10

Hello everyone, I am Harsh Gidra, an undergraduate student studying in National Institute of Technology, Jaipur, India. I am familiar with PHP and MySQL and have developed a number of projects involving these technologies. I want to work on porting the code into an clean OOP structure as mentioned in http://wiki.phpmyadmin.net/pma/GSoC_2010_Ideas_List -- Thanks and regards, Harsh Gidra http://gidraharsh.in

1 0

Re: [Phpmyadmin-devel] GSoc 2010 - Charts in server status page
by Madhura Jayaratne 23 Mar '10

23 Mar '10

>> Hi everyone, >> >> My name is Madhura Jayaratne and I am an undergraduate from the >> University of Moratuwa Sri Lanka. I have few years of experience in >> using php and mySql and was a user of phpMyAdmin for few years. >> >> When I was going through the GSoC idea list I noticed the project idea >> on charts and was interested as I have engaged in developing a general >> charting framework during my internship. I went through the requested >> feature list and had a look at the area of the codebase where I have to >> do the development. >> >> I have few ideas to add in this regard. My feeling is that, before >> adding charts to the runtime information tab we should put in place a >> framework that would allow us to extend charting facilitates wherever we >> want to have it in phpMyAdmin. >> >> What I'm proposing is a general data structure that would facilitate >> multiple types of charts (we can learn a lot from Google Visualization >> API in this regard), and a set of interfaces that would facilitate >> different implementation for different chart rendering engines( we can >> even go for something other than CD2, if we feel like that sometimes >> down the line) >> >> Though this would take few weeks of extra time, I feel that this allows >> a lot of extensibility. When we have this framework in place we can do >> the implementation as for the requirement we have now and we can go on >> to add different charts to phpMyAdimn in the future as the requirement >> arises. >> >> Would love to hear your opinion about this >> >> Thanx in advance >> >> Regards, >> -- >> Madhura Jayaratne > > Are you thinking about a js framework (producing the charts on the > client) or a PHP framework (running on the server). > > -- > Marc Delisle > http://infomarc.info <http://infomarc.info/> > > > What I had in my mind was a PHP framework running on the server. > What do you think about that? > > Regards > -- > Madhura Jayaratne We'll have to see. Please read this list's archives for past discussions a few weeks ago about templating and PHP frameworks. -- Marc Delisle http://infomarc.info Sure, I'll do that and post to the forum if I have any further queries regarding templating and PHP frameworks. Thanx and regards -- Madhura Jayaratne

1 0