April 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] phpMyAdmin 3.3.2-rc1 is released
by Marc Delisle 06 Apr '10

06 Apr '10

Welcome to the first release candidate of phpMyAdmin 3.3.2, a bugfix release. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team -- http://infomarc.info

1 0

[Phpmyadmin-devel] The format of the new documentation.
by Cato Auestad 06 Apr '10

06 Apr '10

Hi, I have had a dialog with Michal Čihař regarding work on a new documentation for the phpMyAdmin project. The reason I am sending out this mail on this mailing list is to ask for input on the format of the documentation. Texinfo is my preferred way of writing documentation, and at the moment the only format I am used to write in. I would like to create a discussion around what format in which the documentation should be written in. Best regards, Cato Auestad

5 9

[Phpmyadmin-devel] GSOC 2010 - Proposal
by Tushar Ghosh 06 Apr '10

06 Apr '10

Hi, I am an undergraduate student studying in India and have found the idea of user interface cleanup quite interesting and something which I feel am capable of. I have 2+ years of web development in php (which involved use of phpmyadmin too). I have worked on the php frontend part of our college's flagship project Codecracker (http://lug.nitdgp.ac.in/codecracker) and have been working to improve my skills at web designing. Some aspects of the interface that I would like to improve upon are: i) The basic framework of the UI needs to be templatized so as to make way for clean codeand this will obviously help to ease addition of utilities to the same. ii) A better looking and more intuitive approach to the SQL editor as it is often used by people who are learning SQL. iii) Also I would like to work on an editor which helps in quick browsing of all source codes in the webroot of the server, so that changes can be made then and there itself and executed. iv) I would like to cut off the no. of pop ups that are displayed as quite a lot of people find them irritating by embedding the login screen in page itself. Also I would like to hear suggestions on more improvements. Regards, Tushar I. Ghosh, Third year, B.Tech NIT Durgapur India

3 2

[Phpmyadmin-devel] GSoC - Server Stats
by Philip Frank 06 Apr '10

06 Apr '10

Hello everyone, I'm a student from Munich, Germany and stumbled across the GSoC Idea of collecting the data that is shown on the server status page and rendering them as graphs over time. I will apply in the next days, here is what I thought of implementing when I'm accepted: Data collection: In the past, I used rrdtool to collect stats on a server. Its datastore has a limited size - over time old entries get merged together and the data gets thinner, but is never completely deleted. Unfortunately, it is not very portable. Therefor, I would implement a similarily behaving datastore ontop of a mysql table. I think of storing each set of measures as a row and limit the number of total rows, making room for new entries by combining one pair of neighbouring old entries together. Plotting: On the ideas page GD is suggeted, but I would prefer to use processing.js, which is a javascript library that draws on a canvas element with a similar usage. To connect to the datastore I would build a json interface for the collected data. Let me know, what you think of it! Best regards, Philip

5 13

[Phpmyadmin-devel] GSOC project - User interface cleanup
by Isuru Udana 06 Apr '10

06 Apr '10

I think it is good to ask from of phpMyAdmin users "what needs to be improved in the user interface?" rather than stick to our own ideas. It will definitely help the future development of phpMyAdmin. In order to get their ideas I am conducting a survey. I would like to share the list ideas I have collected by this survey with other students/developers who are willing to do this project. The list is available at http://spreadsheets.google.com/pub?key=tS9aKmlVo4w3LfJsdmc1l2A&single=true&… If you like to contribute to this list please follow the below link https://spreadsheets.google.com/viewform?hl=en&pli=1&formkey=dFM5YUttbFZvNH… I have uploaded my proposal to http://socghop.appspot.com/<http://socghop.appspot.com/gsoc/student_proposal/show/google/gsoc2010/isuda…>. Please have a look at it and give me a feedback. Thank you -- Isuru Udana Department of Computer Science & Engineering, University of Moratuwa, Web: http://isudana.tk/ Blog: http://mytecheye.blogspot.com/ gTalk : isudana skype: isudana

2 1

[Phpmyadmin-devel] Passing POST variables
by Ninad Pundalik 05 Apr '10

05 Apr '10

Hi, For the last few hours, I've been trying to use jQuery to implement pagination via AJAX in phpMyAdmin. The page I've selected for experimenting is the sql.php page, where one can view a table from a database. I've right now created a javascript file, included it in the DOM via the $GLOBALS['js_include'] array, and bound an AJAX call on the navigation buttons. When I execute the call for a particular table, sql.php replies with the results for the next 30 rows, but it also outputs a lot of other html. As a way around this, I plan to use a variable 'ajax_request', which is set to true when an AJAX call is being made, and accordingly, wrote the jQuery script. If ajax_request is set to true in $_POST, I will modify the output of sql.php and print only the table containing the data from the table, the profiling data, (and any other necessary part) and prevent the printing of the header, footer and other tabs. However, due to the sanitization of $_GET, $_POST and $_REQUEST, I am unable to access the variable. I tried adding the variable name to variables_whitelist and the array_list arrays in libraries/common.inc.php, but I guess those are the wrong places. Could someone please tell me where I'm going wrong, or which is the right php file/function to check? 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

4 27

[Phpmyadmin-devel] GSOC - Export relations scheme other formats
by Kishanthan 04 Apr '10

04 Apr '10

Hi, Im from University of Moratuwa, Sri Lanka and I'm really exited on getting a chance to contribute with phpMyAdmin since it's a really popular software. Im interested in developing the idea : *Export relations scheme to other formats. * *It will be very useful if the relations schemes can be exported to other formats such as dia files, which are much more suitable for inclusion in documents.* *I have experience in working with PHP and MySQL. i have been using these languages for my University projects.* *Please provide me further info on this project, I appreciate all the assistance I can get because I want to participate in GSoC 2010 with a project for this community.* Thanks -- Kishanthan.T

4 16

[Phpmyadmin-devel] Introducing myself for GSoC
by Silvan Troxler 03 Apr '10

03 Apr '10

Hi everyone I'm highly interested in the GSoC project "User interface cleanup". A little bit about me: My name is Silvan Troxler. I'm studying computer science at the university of Zurich (Switzerland) and working as a freelance web developer in my spare time. I also worked for an internet agency for 18 months before I started studying. My task there was to build websites and test them in different browsers. In general I'm experienced in (X)HTML, CSS, JavaScript, AJAX, SQL and PHP (even some other things). Plus I'm a long time phpMyAdmin user (at least five years) and a long time phpMyAdmin theme hater ;-) I'm more a programmer than an excellent designer. But I have an eye for aesthetics and appreciate sleek, minimal and self-explaining designs (as phpMyAdmin should have one). I also would love to express myself in such a well-known project as phpMyAdmin and learn even more about graphics, usability and accessability. I started working with web sites back in 2002. Back to the project: I plan to implement a template engine into phpMyAdmin as a starting point. This will simiplify the further development of the GUI and make it much easier to work with AJAX. For example with the template engine Smarty I made good experience and use it almost everytime. Especially as of version 3 Smarty is very easy to use and implement. Do you have other proposals for another template engine as well? As a further point I would love to get rid of the frames in PMA. With a template engine, this would be not that hard. And of course the UI will be cleaned up but I don't yet have any mockups. If you are interested in my coding style you may have a look at a project I was developing the last six weeks for an university project. It is some kind of bug tracking system which can be integrated in existing websites and collects all PHP errors which occur. With this you can for example collect all E_STRICT errors which where hidden on the web server. It also features a overview page for all errors which occurred with an easy search interface (similar to the one of trac). Consider this application as a veeeery alpha one which needs much of cleaning before beeing usable. This project uses JQuery and Smarty. http://silvantroxler.ch/gsoc/mdudu-0.0.1a.zip (about 360KB) Thanks for your replies and your work on PMA Cheers Silvan Troxler ps: I have to do some kind of internship for the university and GSoC counts as one, so it would be great if I could be a part of this years extending/improving of PMA :)

4 9

[Phpmyadmin-devel] Interested in Participating in GSoC 2010
by Yian Shang 03 Apr '10

03 Apr '10

Hi everyone, I'm Yian, currently an undergrad at UC Berkeley. I am interested in participating in phpMyAdmin's GSoC this year as I've used phpMyAdmin for many years (on a number of web applications) and would like to finally make some contributions. I've looked through the list of project ideas and the source code, and I find that I'm most interested in working on exporting the relations schema to other formats. I'll start going through the source code a bit more and perhaps think about how to export schemas to dia or svg. Out of curiosity, would exporting the schema to dia involve only exporting the structure whereas exporting to svg might have the data (organized in some user-specified way, like maybe by summing certain fields together for everything with the same X)? Best, Yian Shang

3 10

[Phpmyadmin-devel] Ask for patches
by Leonardo Sápiras 02 Apr '10

02 Apr '10

Hi, How can I do to submitt patches? -- Atenciosamente Leonardo Augusto Sápiras

2 2