- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] jQuery in master branch
by Marc Delisle 29 Mar '10

29 Mar '10

Hi, jquery.js 1.4.2 (minified) is now in the /js directory. I converted the slider effect. I am learning jQuery and am pleased so far, but I have two issues with the changes I did: * under MSIE 8, there is no "+" and "-" appearing in front of the link * in the Search page, animation is jumpy (could be related to [0]) Next job I'll do will be the color picker. [0] http://blog.pengoworks.com/index.cfm/2009/4/21/Fixing-jQuerys-slideDown-eff… -- Marc Delisle http://infomarc.info

6 29

[Phpmyadmin-devel] introduction
by mess110＠gmail.com 29 Mar '10

29 Mar '10

Hi all My name is Cristian Mircea Messel and I am perusing my bachelor in IT Engineering at VIA University Denmark. I have been using phpMyAdmin for ages now, ever since I found out what a database is. I am really interested in php and mysqla development, them being the main fields I worked in. Several ideas caught my eye: User interface cleanup, oop and ajax. I have previous experience in developing a forum that also wasn't oop. And converted some of it but that was a long time ago. Also I worked in developing the front end for some audio hardware, where ajax programming was required. The idea is that phpMyAdmin helped me in a lot of ways and now I see a clear pathway for me to give something back. A link to my blog: blog.welcome-to-the-world.com (not that popular) After reading a little more on phpMyAdmin I will post the questions I have Best regards, Cristian

4 9

[Phpmyadmin-devel] seek help to begin contributing to phpmyadmin
by Harpreet .... 28 Mar '10

28 Mar '10

hello sir.. i am a student pursuing graduation in information technology in India. I am interested in contributing to phpmyadmin projects' by coding but i am a beginner in this field and i have no idea about how to begin with. if you could please help me by suggesting me some area i can work on. I have learned programming in C/C++ and also done an academic project in php and mysql. I will be highly grateful to you. eagerly awaiting for your positive response!!! thank you

3 3

[Phpmyadmin-devel] GSOC 2010
by Shreyas Ahir 28 Mar '10

28 Mar '10

Hi All, This is my second post i am planning to participate in GSOC 10 i would love to do charts in server status page. I have one question i hope you guys will give me feedback on that. Adding graphs to run time information is good will help DBA a lot but how about adding certain diagnostic tools like combining explain with this charts showing what mysql parameters one can change like buffer size, indexes for queries and giving ballpark range of how this can improve the performance of certain resource intensive queries and showing all this in a bar graph. Basically comparing the query time at present with query time if the changes are done. I see this can help because when some large query is run on tables with millions of data many times DBA have problem to pin point why server response time is low and what corrective measures he has to take. Thanks and Regards, Shreyas

3 6

[Phpmyadmin-devel] Revamping phpMyAdmin to utilize MVC architecture
by Aaron Maturen 28 Mar '10

28 Mar '10

Hello Everyone, My proposal is to rewrite the architecture of phpMyAdmin with the model-view-controller(MVC) design pattern. With this pattern we will be able to separate all the code into three parts: 1) The Model. This is where the business logic goes. All the code to connect to the database resides here. If we code the adapter pattern here we could potentially give PMA the ability to work with other RDBMS with simple plugins. 2) The View. This is where the template system goes. 3) The Controller. Links the Model(all the data) with the View(what the user sees) Secondary Design Patterns that could be implemented alongside the MVC framework: Singleton: for handling sessions. makes sure that there is only ever one instance. Strategy: for handling languages. allows different languages/themes to be easily interchanged. We can easily add the jQuery library into this to allow the MVC framework to utilize AJAX and be able to transfer data between the classes without a page refresh. Benefits to the users: The MVC architecture will better support scalability and ease modification and maintenance(due to the separation of tasks). Also with the template system and business logic located in separate files comes the separation of the front and back end of the website; resulting in a more robust website. The separation of the design and applications layers allow for increased levels of interactivity without compromising security. By using MVC Architecture and working in an Object oriented format, the website becomes increasingly modular where users can easily add new modules without disturbing the rest of the application. you can view a sample website that I am in the process of transferring to MVC architecture at http://www.ivorypenguin.com/mvc and you can find the source code at http://www.ivorypenguin.com/mvc/mvc.zip I've just got module to allow users to log in. But the architecture is more or less done. Thank You For Your time, Aaron Maturen atmature(a)svsu.edu aaron.maturen(a)gmail.com

2 1

[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