March 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Login form
by Rohit Kalhans 27 Mar '10

27 Mar '10

hi, I know this is silly but can someone please tell where (I mean which file) is the *html output for the initial login form* coming from in the PMA code. -- Rohit Kalhans homepage: http://rohit-kalhans.co.cc BLOG: http://13lackburn.blogspot.com

1 1

[Phpmyadmin-devel] GSoC 2010, my introduction and idea
by Cristian Dinu 27 Mar '10

27 Mar '10

Hello everyone, In the hopes that I will be forgiven for joining the fray so late in the proceedings, I'm here to do my obligatory introduction as a GSoC candidate :) My name is Cristian Dinu and I'm a Romanian EECS student with about 2 years of experience in professional web development. Although I've been an avid user of FOSS for many years now, this is the first time I will be applying my skills to further the cause of open-source development. But one has to start somewhere, and I figure, what better way to begin than by making an improvement to the venerable database administration tool that we all know and love? The idea I've come up for my proposal may seem rather crazy, but I'm confident that I can make it materialize in the short time that is available. Basically, what I want to do is to endow all SQL query editors in phpMyAdmin with IntelliSense-like functionality (obviously implemented using JavaScript). I can't count the number of times I've found myself writing a query, only to have to stop to check the exact name of some field in a table that isn't focused, or this or that obscure bit of SQL syntax. I feel my idea, once implemented, would greatly increase productivity and help many users feel somewhat less frustrated with pma's aging interface. What do you guys think of this idea? Is it really as useful as I think it is? Would it be overkill or burden pma excessively? Before you ask, it goes without saying that the feature would degrade gracefully so that users with JS disabled or unsupported browsers would still be able to enter queries in a plain text field :) Thanks, -- Cristian Dinu

3 2

[Phpmyadmin-devel] GSoC 2010 - OOP Restructuring -PMA
by Swvist Corp 27 Mar '10

27 Mar '10

Hello people :-), I am Vipin Nair, a computer science major, graduating this year form Christ University <http://christuniversity.in/>, Bangalore, India. My course effectively ends on April 7th (my last exam date:-):-) Hurray!!!) which gives me ample time to do what i love the most, i.e. CODE. I have been programming since a fairly young age, but it was recently that i dived into Open Source(Around 3 yrs back) and i am an open source advocate now. I have been using phpMyAdmin ever since i have ever required to use MySQL. I love this tool and would love to contribute back to it. In my final semester major project(a social reminder service), i have used PHP5 OOP for database CRUD (using mysqli) and i think i am fairly good at it. When i saw 'phpMyAdmin OOP Restructuring' in the GSOC 2010 ideas list at phpMyAdmin website, first thing that came to my mind is that i can make an effective contribution to the project, OOP is not new to me and i have spent enough time in indulging in PHP5 OOP which i think will help me a lot if i am required to transform phpMyAdmin into OO. Marc advised me to introduce myself on the mailing list, so here i am with it, i would love to know other people here and get some crazy ideas as well. I do have a small crazy idea for phpMyAdmin, which is in my mind right now. Let me put words to my thought and my next mail will be my Idea for sure. Well thats all about me, and i do hope that i am picked as student for GSOC 2010. Thank you all, Vipin Nair nair.vipin(a)ymail.com

2 1

[Phpmyadmin-devel] email to post to the phpadminlist
by lokesh kadyan 26 Mar '10

26 Mar '10

Hi, I am lokesh. Actually, this is first time i have heard about GSOC, so i was not able to do any prior preparation for it. So, i am working on the already given ideas from phpMyadmin. I have been reading all the rules and regulations of GSOC and very keen to participate in it and work in PHPMyadmin. I have been working with C++, C and LAMP i.e. Linux Apache MYSQL PHP server . As, this is the first time i have participated in any open source program, i have been working hard on the given php ideas for many days and will soon make my report upload in a day or so. And, ya although i have not worked in any open source program but i have worked in my college websites. Regards Lokesh Kadyan

3 2

[Phpmyadmin-devel] GSoC - Statistics, graphs project
by Mihai Chereji 26 Mar '10

26 Mar '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I am a first year Software Engineering student and I would like to take on the Statistics project posted on your idea list. Even though I have not worked with the code base of PMA before, I have used the app for quite some time, and I do have some experience with PHP and MySQL (if needed, I will send the code of the one larger-than-a-few-lines-of-code project I have worked on - a very simple attempt at a CMS). Best regards, Mihai -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJLrQYiAAoJELAfl8DjMdANL24H+QEUvSFYKXxja6ZIwKdc5JrF OS0X5/b8Gv6Fs0YcVjMW8G0dpQGU3Ap0ds72vbiO/cm8HbYXO4/QHX6c9ngrdjmo zqpiWAqJeD6FwI+LG0k4SX93y3F7B8cVRJbQaKC2Fy+uQHvm2PjQSj3O4ksLuIbc RzLKqeCGcZy2/0oSHvQttekrjss/b66E53htnyT0vkFbSKOEypisn+MNLsxUxmgo MzFp7t13nXQgAlPk6dBssS5HsemfEmmc0cRQfAwiOmFw/c/6qCkoGalURlU6pgxb uoBxWb3BzPpO80vraEEChUHJ+jQZn6SojkXqh67ua4dAR1XRFIAF/mEJf7Wndy0= =Cvxm -----END PGP SIGNATURE-----

2 1

[Phpmyadmin-devel] I want to start coding on phpMyAdmin OOP project for GSoC
by Çagatay TOPRAK 26 Mar '10

26 Mar '10

My name is Çağatay TOPRAK, you may print Cagatay. Living in Istanbul, Turkey. Timezone is ETC+2, you asked for. I'm studying Computer Tech and Programming. Almost finished, all exams I passed, now I have some internship to pass. Now I'm studying Economics on Open University to delay military obligation, but I liked it. I was planning to study physics but plans may changed. Contacts; MSN, E-mail: toprakcagatay(a)hotmail.com Website: www.cagataytoprak.com , GSoC Blog: www.cagataytoprak.com/GSoC I planning to replace PHPMyAdmin codes to OOP ones and make them more coder-firendly, so new coders will attempt to join more easily to the projects in the future. To do this, coded a PHP MVC style web framework before, and want to use some of its functionality. Of course I'm open for other and better ideas, spacially working with other guys. First of all, I should have a good understanding of pma codes, then I will use the same UI to fit on new OOP codes. Then I will make seperate all UI's from codes. When this preperations finished, I will recode the functionality by using the old code putting in proper classes. I don't know how much time should be needed for theese. But I will make a time line, and try to go on that. I'm open for other works to do something. Past of my life: Before I worked on some projects on PHP, Java, Javascript and some BI experience by Cognos and Jasper reports. Have good understanding on OOP, Design Patterns, Frameworks. Knownladge of distributed applications, team works, documented projects, etc. _________________________________________________________________ Hotmail: Powerful Free email with security by Microsoft. https://signup.live.com/signup.aspx?id=60969

4 7

[Phpmyadmin-devel] [GSoC] PMA with OOP
by Lex 26 Mar '10

26 Mar '10

Hi all, My name is Aleksey Shilin. I am Russian student and want to participate in GSoC with phpMyAdmin. I would like to participate in reorganizing PMA source code with OOP. Some words about myself : Second year student of Kuban State University of Technology (http://kubstu.ru) Have experience with OO programming ang git VCS. Languages PHP and C#. Worked with frameworks : Yii(http://www.yiiframework.com/) and .NET. Expected workflow: 1. Investigate current source code and make notes. 2. Develop architecture and make UML diagram for it. 3. Discuss architecture in mailing list or with mentor. 4. After approve, start writing unit-tests. 5. After that transfer current source code into OOP architecture. What tasks for patch can you advice, to show my code? I checked tracker, but some of opened tasks have negative response.

2 1

[Phpmyadmin-devel] GSoC About Two Ideas: OOP and UI cleanup UI
by Carlos mauro 26 Mar '10

26 Mar '10

Hi all. My name is Carlos Mauro Cardenas Fernandez. I'm studing a master. Well, people i wanto to participate in GSoc for MPA in this projects: - phpMyAdmin OOP Yeah PMA is a great project. Is very fun and powerfull for a lot of work. I want to create a some classes making groups with the prefix from the original files like: pmd_common.php, pmd_general.php, pmd_pdf.php, pmd_relation_upd.php, pmd_display_field.php, pmd_help.php, pmd_relation_new.php, pmd_save_pos.php to a class: pma_class.php (for example only a first idea). This project is possible but with a little limit but make a refactoring about all code may be create a new. The project is more factible like a redesinged like wrote in other email. But is very important defined a model class with mentor's help. The first step is create package with file with similar prefix and make a class. - User interface cleanup I want to redesing some form using jquery[0] or yui[1] with new datatable fro the grid. May be using google Api, Google have Ajax libraries API[2] and Google Chart Tools[3]. This tools are very powerfull for make a better administration database. I have some experience in this with the api google. [0] http://jqueryui.com/home [1] http://developer.yahoo.com/yui/datatable/ [2] http://code.google.com/apis/ajaxlibs/ [3] http://code.google.com/apis/charttools/index.html -- Carlos Mauro Cárdenas Fernández Ingeniero de Sistemas 4582877 980525716 Creemos en el amor de los Seres Humanos http://forpapers.blogspot.com/ http://unimauro.blogspot.com/

2 1

[Phpmyadmin-devel] The SVN repository
by Kaarel Nummert 26 Mar '10

26 Mar '10

Hi! When adding a patch I get a warning saying "Due to the amount of work required to integrate patches into phpMyAdmin, patches posted in a UNIX diff/patch (preferably unified) format, against 'trunk' in SVN repository will be MUCH more quickly accepted than other code." Is this still relevant? If so where is the SVN repository? The following web page only links to the Git repository. http://www.phpmyadmin.net/home_page/improve.php#devel Best Regards, Kaarel Nummert

2 1

[Phpmyadmin-devel] OOP Restructuring of PMA - One hell of of an Idea!!
by Vipin Nair 26 Mar '10

26 Mar '10

Hello guys, I have an idea for OO restructuring of PMA. I think converting the code to OO will help developers deal with PMA better. The PMA can be divided into four different subparts. They are: 1) Code that deals with Database (Create, delete, alter) 2) Code that Deals with Tables (Create, delete, alter) 3) CRUD 4) Others (User management, sync, etc) The above four sub-parts work together to do what PMA does, but they can also be treated independently. What i am suggesting is that the above four subparts can be converted into 4 different core classes and they can work together. Each of the core classes can have different methods to provide its functionality. Suppose we have a class 'database' for the first subpart and if any other subpart requires to create a database, it has to simply create an object of the database class and call its 'create' method with the required paramaters. This will uncomplicate the code. Each of the above mentioned subpart of PMA can be converted into a class one by one and can be seamlessly integrated to work with other subparts as well. This will help developers code PMA without essentially knowing the structure of PMA. Converting the code to OO helps to create plugins for PMA. All the developers needs to know is the class, its methods and arguments. For example: Suppose a system administrator is using PMA. His requirements are that every time a new user is added into the database, a new table should be created for the user in the database. System Administrator will want to automate his work and he would like a plugin for PMA that can do his work. He asks a developer to create a plugin. If the existing code is restructured into OO code, all that a plugin developer is required to do is that every time a new user is added to the database, a 'table' object is created and its 'create' method is called with appropriate arguments and a table for the new user is created. It could be something as simple as: $table_object = new table(); $table_object->create($username); Think of adding the same functionality with existing PMA structure. A new developer will have to put in a lot of time and effort to understand the existing PMA structure to do something as simple as above which generally discourages them. If the code is converted into OO, all the devloper will need to know is the struucture of the core class 'table'. My point is that PMA can be restructured as OO code, which will be very useful for PMA developers and plugin developers as well. OO restructuring will do a lot good to PMA and it will encourage a lot of developers to create plugins and add functionality to PMA. I think before ajaxifying the UI, if OO restructuring is done it will add lot of developers to PMA, in terms of features and plugins. Once the core OO restructuring is done, UI can be ajaxified to provide a better user experience. Each of the above mentioned subparts can be restructured into OO code mostly independently and i think in the summer time at least two or max three subparts can be restructured as OO code. I would like to know what the developers feel about my idea. Thank you, Vipin Nair nair.vipin(a)ymail.com swvist(a)gmail.com

2 1