March 2011 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] GSoG 2011: Reg Zoom-search idea
by Ammar Yasir 14 Apr '11

14 Apr '11

Hi, We are supposed to select two columns from the table. I wanted to ask that whether we would also have to provide some sort of query interface so that you can select some instance of the column. eg Table -> Movies Column1 -> Popularity | Popularity > 7.5 Column2 -> Year | Year = 2010 Ammar Yasir

3 20

[Phpmyadmin-devel] Proposed theme changes
by Piotr Przybylski 12 Apr '11

12 Apr '11

Hi all, There are some changes I would like to see in pmahomme before release. 1. Table list div#left_tableList li change padding to "1px 0", or "2px 0" (make list more compact) 2. Data tables table caption, table th, table td change padding from 0.5em to "0.2em 0.5em", original padding can be then restored for table headers alone (make data tables more compact) 3. Some other issues, screenshots at [1] 4. Not strictly pmahomme related, but still influencing it - we have width and height defined for icons in navigation bar - we can remove sizes to allow for more flexibility in themes (eg. right now plus/minus and table icons are scaled down) Mike, can you comment on that? I believe we can make some margin changes while regaining good readability in theme and would really like to see some changes there :) [1] http://img861.imageshack.us/img861/5554/pmahomme.png -- Piotr Przybylski

3 8

Re: [Phpmyadmin-devel] GSoG 2011: Reg Zoom-search idea
by Ammar Yasir 06 Apr '11

06 Apr '11

On Sat, Mar 26, 2011 at 4:20 PM, Marc Delisle <marc(a)infomarc.info> wrote: > Le 2011-03-25 16:02, Ammar Yasir a écrit : > > > Thanks for the comments. I'll try to include all possibilities (using > > existing pChart or SVG) in my proposal. One more question, it was > required > > on our part to submit a patch before we submit our proposal. > > I submitted a patch for mass table prefix change ( > > > http://sourceforge.net/tracker/?func=detail&aid=3220779&group_id=23067&atid… > ). > > Its for one of the 'Tasks for Junior developers' and its working fine > (nijel > > verified that) but not accepted yet, so will it count or I'll have to do > > something more before I could submit? > > I changed the resolution to "accepted" and you don't need to send > another patch before sending your project proposal. > > Thanks I had a doubt (it might be silly but I thought I should ask). One important feature of such a data visualization system is that it should not create confusion or represent something that the data is not. Consider the movie database example, when a user sees a plot of ratings vs year / genre vs lanuage, a lot of data points will overlap. So a lot of data will be hidden from the user at the first sight. What will a user make out of it? I know we handle such conditions by providing all the data instances when he clicks on the point but a user might not go that far. If he is not able to understand the initial plot he might not continue further ( like not zoom in/click data point). I am just a little concerned about the usability part and not the functionality. -- > Marc Delisle > http://infomarc.info >

3 8

[Phpmyadmin-devel] 64x64 logo/icon
by Michal Čihař 05 Apr '11

05 Apr '11

Hi all looks like it would be useful to have some official 64x64 logo/icon. Right now it would be useful for GSoC website, but I'm sure I've seen such requirement somewhere else as well. Any volunteer to do that? :-) -- Michal Čihař | http://cihar.com | http://blog.cihar.com

5 13

[Phpmyadmin-devel] Interested in AJAXify Interface project idea
by lgtkaushalya＠gmail.com 03 Apr '11

03 Apr '11

Hi Marc, > Please checkout "master" instead. > > I have then re checkout the "master" and checked for the functionality of the search option. > > One area that needs improvement is Database search: > - collapse/expand the "Search in database" fieldset > - separate popup when clicking on Browse in the search results, to avoid > losing the search results; the same for Delete (especially when a Delete > attempt fails) > > When I tried to search using PMA it gives unexpected UI panel repeating within the result window. I check it with the version 3.3.7 and in that it works fine. Here is the link which I have showed the screen shots of the results which I get. Here the "Tab navigation bar [1]" and the "Search in database[2]" panels showed twice. https://docs.google.com/document/d/1eEEgOemO8uhkzAw_aFYOSwHDKYZeiLRPuVDjAHx… I'm Using Ubuntu 10.10 as the os, apache-2.2.16 as the server and using a symlink to the phpmyadmin folder and Google chrome as the browser for testing this. Can you clarify whether this is a bug. > > Are you familiar with jQuery? > > Last few days I went through some jQuery tutorial and now having some basic knowledge on it. So I'm willing to start working on the improvements you have mentioned. Are there any standards which should I follow in PMA UI designing. I will start working on the task of -collapse/expand the "Search in database" fieldset. But in the -separate popup when clicking on Browse in the search results, task needs a better structure. So may I draw a wire-frame for that UI, so you can correct me if it needs any modification. Regards, Thilanka. -- http://coders-view.blogspot.com/ http://thilankagekawuluwa.blogspot.com/ http://twitter.com/thilanka_k

3 40

[Phpmyadmin-devel] GSoC 2011: Browse-mode Improvements ++
by Aris Feryanto 03 Apr '11

03 Apr '11

Hi, Previously, I have emailed some of my suggestions on User Interface Cleanup project. But after doing some research, I found that compared to User Interface Cleanup project, Browse-mode Improvement project will provide me to achieve the satisfied result and bring me higher chance of success. I have submitted a proposal on this project and also have added some ideas besides feature requests listed on the phpMyAdmin Ideas Page. The following is my suggestions for this project. Any comment and suggestion are welcome. Synopsis: This project is intended to improve the convenience of users when using phpMyAdmin, particularly when browsing tables. This can be achieved by adding the following features to phpMyAdmin: •Browse recently used tables •Remember the last way user sorted tables •Flexible table’s column width •Reorder table’s column using mouse during browsing •Show only selected columns •Integration of navigation bar •Edit only selected field •Grid view in the table edit page Project Details: •Browse recently used tables Interface As discussed in the feature tracker , we can show recent tables that have been viewed by user as a drop-down list in the navigation frame. To keep things simple, the preferences will only show a checkbox “Display recent [#] tables” with the [#] default to 10 and can be set by user. Storage Recently used tables can be stored in phpmyadmin database if it has been configured or in session variable if it is not. •Remember the last way user sorted tables Sorted column of each table can be stored (if the table is ever sorted) in phpmyadmin database or in session variable. When user browse a table, this value is read and added to sorting criteria of the SQL select query. This value must be synchronized with current database, i.e. when user drop a field, table, or database, the corresponding sorting value must be deleted. Up to three points below are inspired by: http://www.flexigrid.info/ by Paulo P. Mariñas •Flexible table’s column width & reorder table’s column using mouse during browsing We can add functionality to adjust width and reorder table’s column by using jQuery. Again, table’s column order can be saved in phpmyadmin database or in session variable. An option “Remember tables’ columns order” can be added to the preference page. •Show only selected columns Currently, users have to run a SQL SELECT query or create a VIEW to display only certain columns from a table. This is sometimes cumbersome. We can improve this by adding a drop-down list in table’s header, giving checklist options to show only certain columns. This can be done by using jQuery. •Integration of navigation bar Current interface of navigation bar (prev, next) and “Show # row(s) starting …” can be integrated with the query-result table. So it will look like a part of the table and make user more convenient to use the navigation. •Edit only selected field One way to achieve this: modify current edit page to show only selected field. When user runs a select query, select some rows, and then click edit, some variables will be passed to edit page, so it hides fields that are not shown in the query result. Alternatively, an option to show/unhide all fields can be added. •Grid view in the table edit page Sometimes, users want to be able to edit only certain selected rows, but with a browse-like view. (Think of actions: browse -> select some rows -> With selected: edit) I am thinking of improving the edit page, so user can have an option to edit table in a grid view instead of current edit view. The grid view will be simple, 2D grid, like in browse table. Each cell will be resizable text field, where user can change the value directly by typing in it. I think this will be a complement of inline edit, since we can edit TEXT type value (which cannot be edited in inline edit).

3 5

[Phpmyadmin-devel] GSoC Ideas
by Michael Bundy 02 Apr '11

02 Apr '11

Hello, I'm a second year CS and EE at Bristol University, England. I have exams until the 17th of June. I know officially students are meant to start on the 23rd of May, and I would be willing to make a start then, but since I have exams around that period, I wouldn't be able to work on it full time until the 17th. Would this be a problem? Okay, I'm thinking of putting forward 2 proposals, both from the idea's page. But before I do, I need to clarify a few things. *Zoom Search* (and more AJAX) I'm not sure if anyone has ever looked into it, but jqPlot looks like it'd be ideal for this. It already has a zoom feature, offers a bit of "shininess", and would be quite straight forward to implement, I feel. Since pma is already implementing jQuery, using a plugin of it makes sense. jqPlot also offers a simple line of best fit. Would a few more simple mathematical functions (K-means, standard deviation, Cov?) be worth it? While I don't expect anyone to want to do anything serious in a browser, it might be worth it to have a simple way of viewing trends without having to export the database to something like matlab. Even with the extra mathematical functions, I feel like it probably wouldn't take much time to implement - i.e less than 4 weeks - and adding more AJAX seems to be the idea that naturally fits. If this seems like a good idea I'll look more into the AJAXify part. (and probably try 1 or 2 for a contribution) Failing that, dealing with the "Browse-mode improvements", I feel that working full time on that, I could probably get through most of that list in about 4 weeks, especially since jQuery can be used. The main question here is would phpmyadmin save thing's like the last view table or SQL command in a flat file, use the database or have a choice? The jqPlot website has a lot of examples on it ( http://www.jqplot.com/tests/ ) I'm currently working on the concept, though its still a WIP and right now only displays random data. Still, I think it should shows that doing what is required should be quite straightforward. http://mirey.pcriot.com/zoom.php *phpMyAdmin OOP* This seems like a massive job, as it'd be rewritting the whole of PMA. Would there be any opposition to using a framework such as codeigniter? I guess the main question is, would it use none of the old code until it is finished, or would it there be a period where it would be OOP and the old procedural stuff? An argument against CI is that people would have to learn how to use CI. But I'd argue that having an arbitrary way of doing it would be more time consuming to learn, and people are likely to know how to use CI, or something similar anyway. Would it be worth splitting this down into a number of student projects, each focusing on a particular part? I'd ultimately like to do this, though before I think about it further, I'd want to know whether I could use a framework, or if it would need to be from scratch. Thank you, Mike

4 4

[Phpmyadmin-devel] MySQL queries
by Samiran Raj Boro 31 Mar '11

31 Mar '11

I am not so sure whether to post it here or not. As I have decided to work on Stored procedure support for GSOC project, I need these answers. 1) What are the risk of using mysql database in MySQL? Why is it always suggested to use information_schema instead 2) What is the difference between 'name' and 'specific_name' in mysql.proc? These two seems to be same than why do we need two. Samiran

3 6

[Phpmyadmin-devel] Please help Sir,
by masterxxx7＠ilive.ro 31 Mar '11

31 Mar '11

please send me the password, because I missed the sterile MySQL phpmyadmin and I can not login with old password: edcwsxqaz123 more hostname: masterxxx7.ilive.ro user: admin(a)masterxxx7.ilive.ro parola: edcwsxqaz123 please help and send my password

1 0

[Phpmyadmin-devel] Interested coding for phpmyadmin in GSoC
by Madis Rääk 31 Mar '11

31 Mar '11

Hi everyone, My name is Madis and I'm a student from Tallinn, Estonia. I'm currently studying at the Estonian Information Technology College. My major subject is Systems Development. I have been a using phpmyadmin for about two to three years now. So far your tool has been invaluable for me during the development of web applications. Unfortunately I have been using it as a basic user. And that means I don't have any specific ideas what to develop. But I want to show you guys that I am very interested in coding phpMyAdmin for the GSoC. Mostly I have knowledge in PHP, HTML, CSS and Mysql so anything with these would be nice. Going to download the latest source code from the git repository and try to work with your bugs in the bug tracker. So, give some feedback and how to get more involvede with phpMyAdmin. Take care, Madis

2 1