- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] GSoC phpMyAdmin OOP
by Fábio Albuquerque 23 Mar '11

23 Mar '11

My name is Fábio, I'm a student of Computer Science at Federal University of Paraíba, Brazil, and an enthusiastic of GSoC. As I've working with phpMyAdmin in the last two years, I'd love to contribute and to improve this excellent tool. I'm interested to implement some object oriented improvements on some existing module/functionality, like import or export a database, CRUD operations, etc. I'm studying the phpMyAdmin code base (and documentation), looking for some bit of code which needs to be refactored or could be encapsulated into a class. Maintaining a OOP code is easier and we can make it much more re-usable and self-independent, mainly when the code is re-utilized, like various phpMyAdmin functions, so any improvements are welcome, of course, with a good test covering and an excellent analysis of the consequences into the code. Although I've never had posted/committed any bug solution, I'd like to be closer to the project and this opportunity came right on time, since I worked the last two year entirely with php/mysql (I finished a social network for tourists which is about to be launched soon) and it gave me an excellent experience (since I worked with a lot of design patterns, discovering and correcting pitfalls and traps in PHP language, and good part of the development driven by tests). So, I hope I can mix my experience with an opportunity to increase a tool which I constantly use, beside the chance to be in touch with the leaders and the team of this development. I know is necessary a 40 hours per week, along the 12 weeks, so I'm wondering, maybe I can use the free time between the deadline to rank the students and the real coding beginning, in order to gain some time to give the project some tests (it's obvious we'll need some unit tests to keep the system saved), even start the coding (since I'll still having some classes during the first month, unfortunately), and discuss the idea so we can enhance the improvement :) Is there anything else I can do beside exploring the code? How can I discuss the focus of the implementation? I just can't wait to work with it and finally make my real contribution. Thank you all in advance. Best Regards, Fábio Cruz B. de Albuquerque

5 5

[Phpmyadmin-devel] Question regarding GSOC Idea
by Botea Răzvan 23 Mar '11

23 Mar '11

Hi there. I'm a student who's interested in your web application "phpMyAdmin", and I convinced I could help you in some "issues" posted as ideas here [0]. To be precise I'm interested in making phpMyAdmin more interactive by further enhancing AJAX support for the app. As I've seen, you already use the jQuery API which will make my work less tiresome. I have a question regarding the "AJAX" idea. This seems straightforward: make all those actions through a xmlhttprequest (ajax) . I see some of them are marked as done. Where will the php scripts for ajax reside? For example "Insert rows with an Ajax request: todo": I'll make a function in common.js for a ajax request (with the help of jQuery API), yet I'm not sure what will happen next: if I just make a redirect it will feel like no ajax was made whatsoever. I'm guessing that the user will remain on the same "insert rows" page for any further additions, and maybe add message on top of the table if it had succeed. Correct me if I'm wrong. I'm familiar with AJAX and a bit of jQuery, but I need to know what exactly is intended to be done with them. I'm not very sure how should I elaborate the AJAXify idea since for it's pretty much straightforward on how to resolve it. [0] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List -- Botea Răzvan

2 1

[Phpmyadmin-devel] Patch "POST inline edit data only if needed"
by Marc Delisle 23 Mar '11

23 Mar '11

Hi, as part of solving this bug [0] please test this patch [1] against current master and report in the patch tracker. [0] https://sourceforge.net/tracker/?func=detail&aid=3220370&group_id=23067&ati… [1] https://sourceforge.net/tracker/?func=detail&aid=3234554&group_id=23067&ati… We'll still need to find a way to display the updated timestamp, but at least with this patch the timestamp is updated in the modified row. -- Marc Delisle http://infomarc.info

2 3

[Phpmyadmin-devel] Gsoc Idea: Zoom Search
by Dushy＠nT T!wAr! 22 Mar '11

22 Mar '11

Hi, This is some of my suggestions for the project zoom search proposed for gsoc2011. Project: Zoom Search Summary: Zoom search is a feature to represent the data in a graphical manner. The original idea proposed was to make a 2D scatter. But this idea is meaningful only for fields with numeric values. The idea can be extended to make charts which meaningfully classify data and provide a visual representation. For example for fields with data type *enum* we can make pie charts and zooming into the pie chart will result in providing greater details about the data points lying in that region. User can select the type of chart (pie, bar, frequency, 2D scatter etc) he wants at any juncture of time and depending on the level of zoom and the fields to relate the desired chart can be made. Some additional features: 1. Update feature for a data point: The record can be updated graphically by selecting the data point. 2. Deletion of record using the data point. 3. Grouping of similar records: Data can be represented in the form of stacks. For example one stack can contain movies pertaining to the same year. Zooming in the stack will result in greater details. 4. Can be combined with the result set of custom queries of the users. Rationale for doing this: 1. Data can be better interpreted in graphical form by the end user. 2. It will provide a user friendly approach to view/manipulate desired data. 3. WYSIWYG approach. 4. As I propose to develop it as a plug-in, it can be used by other applications also easily. Development methodology: As the other projects suggests the community is moving towards ajax for phpmyadmin. Development using ajax, php ,javascript will prove to be useful. Moreover the development will be as a separate api without disturbing the core of phpmyadmin so that it will not interfere with the simultaneous and future changes in the core. These are a few suggestions from my side for the project. I will append the list and refine the features as they will occur to me. I will come up with an implementation plan in detail soon. Also comments and suggestions are welcome on this project. I would like to take this as a gsoc project. -- Dushyant Tiwari BITS Pilani KK Birla Goa Campus

2 1

[Phpmyadmin-devel] Interested in GSOC project
by 陈岳峰 22 Mar '11

22 Mar '11

Hi All, My name is Dennis Chen, a postgraduate student in Tongji University, Shanghai , China. My major is Pattern Recognition and Intelligent Systems and my research direction is text mining. I have internship experiences in companies like BOSCH, NEC and IBM, worked for projects which involved C/C++,php, javascript and perl. In the company of IBM I took care of nearly all php projects of the team, including a web monitor for storage system (php & dojo), an interview system for interns (symfony framework & JQuery), a machine reservation system( php & JQuery) and other small web tools. It's an disappointment that I can not show you the sanpshots of these projects. I really love web programming and I even developed an app as the birthday present for my wife, I can show you some snapshots: 1.png<http://www.likegermans.com/gsoc2011/1.png>is the initial status of the app. I prepared many questions for her and if she answers correctly the puzzle will become more in order and otherwise more chaostic. 2.png <http://www.likegermans.com/gsoc2011/2.png> is the final status if my wife can earn 100 points. I apply the magic of CSS Sprite to form the puzzle. You can see that I use many components in JQuery UI to make this app. Recently, I just added a new feature to a BBS of a group of friends of mine: users can twit others in the posts. They love it! As a frequent user of phpMyAdmin, I'm really desired to contribute myself to this project. I've read the applicant guide, I understand that I need to do some bug fixing work, but I don't quite understand how to find a proper bug or feature to fix, do you have some suggestions? by the way, if lucky enough, I hope that I can take the mission of 'Ajax' or ''Support of procedures' in the idea list Best Regards, Dennis Chen

7 29

[Phpmyadmin-devel] phpMyAdmin participating in GSoC 2011
by Michal Čihař 21 Mar '11

21 Mar '11

Hi, It's now official, phpMyAdmin has been accepted as a mentoring organization for GSoC 2011 (refer to http://google-melange.com) We would like to invite all students to participate, though only the best ones will be chosen. Please refer to our applicant guide at http://wiki.phpmyadmin.net/pma/GSoC_2011_Applicant_Guide for more information about application. -- Michal Čihař for the phpMyAdmin team

4 5

[Phpmyadmin-devel] GSOC: Support for procedures
by Samiran Raj Boro 21 Mar '11

21 Mar '11

I have experimented with the current capability of phpmyadmin with stored procedures, triggers, routines and events. As this project aim to create an user friendly interface in phpmyadmin I have some ideas to improve it and also some questions. Currently phpmyadmin supports the above mention features of mysql only with sql queries. While creating procedures with ";" in between delimiter have to be changed. My view is why the user have to take care of it. We can pass some default delimiter to PMA_sqlQueryForm with the delimiter added to our query. So for that I suggest to create separate query box to deal with those things and this would be in a tab "Routines" for each database. It can even be better if we display the list of routines in the database page (the page one gets by selecting a database) and also the names of the trigger associated with a table when we browse it. Again as ALTER PROCEDURE<http://dev.mysql.com/doc/refman/5.5/en/alter-procedure.html>, ALTER FUNCTION <http://dev.mysql.com/doc/refman/5.5/en/alter-function.html>does not allow us to change the parameters or the body, we can make a interface to change its parameters and body. We can program such a way it automatically drops it and create it with the same name with the modified changes. Are my ideas meet the needs of phpmyadmin. Please let me know and suggest to make it better. With regards, Samiran Raj Boro SF nickname: srajbr <https://sourceforge.net/users/srajbr> IRC nickname: samiran

2 1

[Phpmyadmin-devel] default Configuration values in Documentation
by Dieter Adriaenssens 21 Mar '11

21 Mar '11

Hi All, At this moment, the Documentation page contains a list of all available Configuration options [0], with a small explanation of what it does and the possible values, but it doesn't show what the current default value is. I know it is possible to check the default value in the libraries/config.default.php file, but for most users it would be more convenient to look it up in the documentation. Should we add the default value to the Documentation? As the default values are readily available, the Documentation page could be synchronized with a script. What do you think? [0] http://www.phpmyadmin.net/documentation/Documentation.html#config Kind regards, Dieter

3 2

[Phpmyadmin-devel] Bug: ID: 2107746 Warn about incomplete exports
by Piyush Mishra 21 Mar '11

21 Mar '11

Hi Developers, I am new to the PMA community and relatively new to the codebase. I've hit a road block with a bug and would appreciate a lot if some seasoned developers would help me get over the problem. Link: https://sourceforge.net/tracker/?func=detail&atid=377408&aid=2107746&group_… Please read the comments. Narrowed down the problem to being from php.ini 's safe mode setting which doesn't let set_time_limit override default max_execution_time in php.ini After making a rough idea of how the export works in PMA it struck me that we can use the function that basically outputs every line in all types of output. [install dir]/export.php > PMA_exportOutputHandler to check if we are going to run out of time http://pastebin.com/8BCSN7es I made these changes from around line 110 search for function called PMA_exportOutputHandler and you'll find it. Now the final lines on my download give out the line "It's gonna blow!!!" last few lines. http://pastebin.com/BEbv42Ds Now I need to make sure that 1. User gets an error. (session or something? $GLOBALS['message'] = PMA_Message::error(); is of no use for files going line by line :( ) 2. The function passes back the last output line or may be redirects for another file download for lines after the current one being output. Can you guys think of any other scenario for an error (except for safe mode) and can you guide me on shooting out the errors? Worst case scenario we can use the error handling function for a fallback but I want to make a clean solution if possible. -- Regards Piyush Mishra http://www.piyushmishra.com/ Life's Short, Live it to the maximum

1 0

[Phpmyadmin-devel] Fwd: GSoC 2011 OOP : Want to join and help in bug fixin
by Dieter Adriaenssens 20 Mar '11

20 Mar '11

Hi Piyush, Your SF.net E-mail address doesn't seem to work (yet), so I send my answer to your mail (see below) to the developers mailing list. I hope you are subscribed to it. Kind regards, Dieter ---------- Forwarded message ---------- From: Dieter Adriaenssens <dieter.adriaenssens(a)gmail.com> Date: 2011/3/20 Subject: Re: Want to join and help in bug fixin To: piyushmishra(a)users.sourceforge.net Hi Piyush, 2011/3/20 <piyushmishra(a)users.sourceforge.net>: > Hi Dieter, > I am a GSoC aspirant. > I wish to apply for making phpMyAdmin Object Oriented using > popular / new programming patterns in php. Just to be clear, the scope of the GSoC project is not to convert phpMyAdmin completely into OOP. Doing so would mean almost a complete rewrite of the current codebase, and at this moment the team has no plans in doing so. The GSoC OOP project is about turning a small part of phpMyAdmin into OOP, f.e. turning a somewhat standalone module into OOP, or turning a commonly used 'object' into a class, and refactor the code of phpMyAdmin into using that class. Take also into account that the proposal you make should be feasible in the set time frame of GSoC, ie. 12 weeks of approx. 40 working hours. This includes, creating the class, implementing it in the phpMyAdmin code (at least, your branch of it), refactoring, testing and documenting. > What version of php are you planning to use for the new OO > phpMyAdmin? (I have made a half-baked front controller > framework on php 5.3.x, trying to use dependency injections) At this moment, phpMyAdmin 3.3 (and upcoming 3.4) should work on 5.2 or higher, so you cannot use things that are only present in 5.3 or higher. You might want to take a look at this article about design patterns : http://www.ibm.com/developerworks/library/os-php-designptrns > Currently, I am trying to familiarize myself with the > codebase of phpMyAdmin and may be help fix some bugs along > the way. Good, it is a requirement to fix some bugs before the end of the application period, so that we can see how you work and if you understand the phpmyadmin codebase. > I am new to sourceforge (am familiar with git though) and > phpMyAdmin also. > I have used it and have been bitten by a particular bug and > would like to try fix it. > https://sourceforge.net/tracker/?func=detail&aid=2107746&group_id=23067&ati… Go ahead, post a message on the tracker you will be taking this bug on, and submit your solution on the patch tracker (as is described in FAQ 7.3 : http://www.phpmyadmin.net/documentation/Documentation.html#faq7_3) > I have added you on facebook. I'm not going to add you, I only use Facebook for close friends, I hope you understand. Good luck with GSoC and with submitting your application. Kind regards, Dieter

2 1