March 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] GSoC 2010 proposal - User Preferences
by Piotr Przybylski 09 Apr '10

09 Apr '10

Hi, I would like to take part in this year's Google Summer of Code to implement the User Preferences proposal. I took part in GSoC two years ago, implementing phpMyAdmin's new setup script, which I hope works as intended :) Currently I am on the first year of postgraduate course for master's degree on Poznań University of Technology, specialization - Data Processing Technologies. In accordance with project proposal, all settings would be stored in pmadb, with an option for easy export and import. User will be able to change all relevant PMA features which do not affect performance or security settings. After taking a quick glance at config.default.php I believe these settings should be considered for customization: * DROP confirmations * show executed sql (ShowSql) * LeftFrame*, table comments in tooltips * displayed rows * INSERT form customization * default files (DefaultTab*) * maybe export/import default options? * MySQL manual type * window title * SQL Query box settings * hiding some tabs under one drop-down menu (eg. I have never used Designer or Query by example for database / Import for single table) -- Regards, Piotr Przybylski

3 21

Re: [Phpmyadmin-devel] [Phpmyadmin] Interested in Participating in GSoC 2010
by ANKIT GUPTA 07 Apr '10

07 Apr '10

Hi, because of the size limit , i am resending the my previous mail but this time in place of attaching the image i am providing a URL URL for image: http://dl.dropbox.com/u/1008346/mock_schema.jpg PFA with this mail as marc Suggested that we should discuss the design with the help of an example, so i have made a mock schema with three tables artist,song and sings.details u can see in the diagram with this mail. i know The Design which i have developed till now is just the beginning draft , lot of discussion and thought has to be put to finalize the design with functionality. Its my Bad to miss the having clause,we can put it in with the Group By option in menu bar(see the diagram). I got a comment from Michal cihar that this time phpMyadmin is selecting only those students who have contributed something before,but i have not contributed to phpmyadmin till now. But i am willing to contribute can anyone please suggest me some bugs to fix and which can be done in the given timeline also please tell where to find documentation for developers,explaining overall structure Thanks, Ankit Gupta 2010/3/31 ANKIT GUPTA <ankitatbits(a)gmail.com> > Hi, > > PFA with this mail > as marc Suggested that we should discuss the design with the help of an > example, > so i have made a mock schema with three tables artist,song and > sings.details u can see in the diagram with this mail. > > i know The Design which i have developed till now is just the beginning > draft , lot of discussion and thought has to be put to finalize the design > with functionality. > > Its my Bad to miss the having clause,we can put it in with the Group By > option in menu bar(see the diagram). > > I got a comment from Michal cihar that this time phpMyadmin is selecting > only those students who have contributed something before,but i have not > contributed to phpmyadmin till now. > But i am willing to contribute can anyone please suggest me some bugs to > fix and which can be done in the given timeline also please tell where to > find documentation for developers,explaining overall structure > > Thanks, > Ankit Gupta > > > > ---------- Forwarded message ---------- > From: Michal Čihař <michal(a)cihar.com> > Date: Wed, Mar 31, 2010 at 7:39 PM > Subject: Re: [Phpmyadmin-devel] [Phpmyadmin] Interested in Participating in > GSoC 2010 > To: phpmyadmin-devel(a)lists.sourceforge.net > > > Hi > > Dne Tue, 30 Mar 2010 23:06:43 +0530 > ANKIT GUPTA <ankitatbits(a)gmail.com> napsal(a): > > > i have already tried that command but it is also not working,i am getting > > following error > > fatal:unable to connect a socket (connection timed out). > > See > > http://wiki.phpmyadmin.net/pma/Devel:Git#Accessing_Git_repository_from_behi… > > > I also want to discuss about the design for visual query designer,i have > > thought of some points like > > to add an option button with each selected attribute of table where we > > will have a menu bar with following fields GROUP ,ORDER ,Rename and > Where. > > As user selects option from this menu bar other boxes/options will > > appear as the case is. > > > > i am planing to implement select from clause,joins,group by order by and > > various aggregate function in query builder.you can check further details > in > > my Gscoc Application . > > > > please suggest any other functionality which we can add or any > additional > > features in the design. > > You did not explicitely mention HAVING clause... > > -- > Michal Čihař | http://cihar.com | http://blog.cihar.com > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Phpmyadmin-devel mailing list > Phpmyadmin-devel(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel > > >

4 17

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

04 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] problem with _pgettext() in English (US)
by Marc Delisle 01 Apr '10

01 Apr '10

Hi, in libraries/messages.inc.php we have $strCreateTableShort = _pgettext('$strCreateTableShort', 'Create table'); This gives a good result for all languages I tried, except English (US). -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Gettext now used in master
by Michal Čihař 01 Apr '10

01 Apr '10

Hi all as announced earlier, phpMyAdmin now uses gettext for translations in master branch. As this changed quite a lot how the translations are being used, I've written down guides for it to our wiki. If you want to translate, you can find the information here: http://wiki.phpmyadmin.net/pma/Devel:Gettext_for_translators And for the developers it is available here: http://wiki.phpmyadmin.net/pma/Devel:Gettext_for_developers -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 3

[Phpmyadmin-devel] GSoC
by Gustavo Henrique Lima Pinto 31 Mar '10

31 Mar '10

Hi everyone. My name is Gustavo, a phd student from Brazil, and I'm also interested in participate into gsoc. I became interested in the topics provided by Helmo. Does anyone else have subscribe to these topics? Where I can find Helmo to discuss about it? Best regards.

2 3

[Phpmyadmin-devel] RFC: Integerating mysqltuner into phpmyadmin
by Raj Shekhar 31 Mar '10

31 Mar '10

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. More info at <http://blog.mysqltuner.com/faq/> I am currently porting this script into a PHP class, that will have these public functions - - constructor - analyze - get_variable_tuneups - get_general_tuneups - get_engine_tuneups (not yet ready) I wanted to see if there is some interest from the PMA developers in integerating this into PMA. Currently there are tabs to show the variables and status counters (server_status.php and server_variables.php). I was thinking of a server_tuneups.php script that would print out tuning recommendations. This is not a GSoC project. Let me know what you think. Thanks, Raj Shekhar

3 7