January 2011 - Developers - lists.phpmyadmin.net

[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] Interested in project ideas for GSoC 2011
by Madhura Jayaratne 27 Mar '11

27 Mar '11

Hi All, When I was looking at the 'Idea List' for GSoC 2011, I came across two project ideas that interest me. I would like to know more about these ideas, so I would be able to focus on one specific project idea. The first project idea I'm interested in is 'OpenGIS support' [1]<http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support>. As a first step I went through the MySQL documentation on 'Spacial Extension' [2]<http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html>. I would like to know a rough outline of the features that is expected to be implemented under OpenGIS support. The second project idea that caught my interest is 'phpMyAdmin_OOP' [3]<http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP>. Undoubtedly, when implemented this would help the life of developers much easy. I would like to know the expected scope of this project. Further I would appreciate if you could direct me to any articles or documentation I should read with regard to this. [1] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support <http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support>[2] http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html <http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html>[3] http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP <http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#phpMyAdmin_OOP> -- Thanks and Regards, Madhura Jayaratne

3 6

[Phpmyadmin-devel] Getting involve!
by Kasun Lakpriya 23 Feb '11

23 Feb '11

Hi all, I am Kasun Lakpriya from Univesity of Moratuwa, SriLanka. I am following a BSc in Computer Science and Engineering and now I am in my final year. I have participated in 2010 Google Summer of Code and worked for Apache Software Foundation's Directory project. My work with mentor can be found here [1]. I have PHP, MySQL knowledge and unit testing knowledge in Java. While I am going though some interested projects I found phpMyAdmin wiki has some interested ideas. I am very much interested about the second idea [2]. I installed Git and cloned the phpMyAdmin module to my Ubuntu 9.10 machine and had a look into some of the code. And now I am looking into Selenium tests. I would like to work with you all to get familiar with the code-base. Your ideas are welcome to get me started with phpMyAdmin! Thank you, Kasun [1] - http://code.google.com/p/dirstudio-ldap-tooling/ [2] - http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#Automated_testing

3 13

[Phpmyadmin-devel] XML export/import : view of view
by Dieter Adriaenssens 08 Feb '11

08 Feb '11

Hi all, I'd like your opinion about exporting view of view in xml format. Aamir Khan prepared a patch [0] that creates an XML export in the way this is handled in SQL export, ie first all tables and views are exported. All views are exported as standin tables with the same structure. Then all views are recreated, first dropping the standin tables, and creating the real views. The reason for this is to make sure that when creating a view that uses another view, it at least exists, thus avoiding an error upon importing it again. Downside of this is that the xml export of the structure schema gets a bit confusing with a <pma:table>, <pma:drop> and <pma:view> tag for every view, as the xml export is intended to be used by custom scripting. Another idea is just to export the schema structure with one tag for a view (without the extra table and drop parts), and make some changes to the xml import code, to handle the correct creation of the views. Any ideas? [0] http://sourceforge.net/tracker/?func=detail&aid=3141565&group_id=23067&atid… -- Kind regards and Merry Christmas, Dieter Adriaenssens

4 9

[Phpmyadmin-devel] discussing wiki changes
by Isaac Bennetch 05 Feb '11

05 Feb '11

Hello, For those of you who are involved with the wiki, there are a few large changes we're discussing. Michal proposed that this might be the best vehicle for discussion, which seems to make good sense to me. First: Marc basically suggested creating subcategories for "Google Summer of Code"; that would be the parent category with subcategories like "Google Summer of Code 2011". Then pages like "GSoC 2011 Ideas List" would be in "Category: Google Summer of Code 2011" which would then in turn be "Category: Google Summer of Code". "GSoC 2011 Ideas List" would not appear directly in "Google Summer of Code". Any objections? Second: It's been proposed to completely abandon namespaces (such as Devel:) -- in some cases they can help, such as when a page clearly belongs only to one namespace or the other, but many of our pages (for instance, the GSoC pages) either live in the wrong namespace or could be assigned to both. I do agree that everything currently in Devel: belongs there, but some things in the (Main) namespace probably belong in Devel: and it might be easier to administrate only one namespace...Then we wouldn't have to think about (or discuss) which namespace a page belongs to or move it if content changes. What do you think?

4 11

[Phpmyadmin-devel] Templating project
by Anirvana Mishra 02 Feb '11

02 Feb '11

Hi everyone, I see an exciting idea 'Templating' [here<http://wiki.phpmyadmin.net/pma/GSoC_2010_Ideas_List>], If that project is still open, Can I contribute? -- Cheers Anirvana Mishra

4 7

[Phpmyadmin-devel] GSoC 2011 idea: Zoom-search
by Marc Delisle 01 Feb '11

01 Feb '11

Hi, I just added a new idea : http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#Zoom-search -- Marc Delisle http://infomarc.info

2 8

[Phpmyadmin-devel] Redirecting external links
by Michal Čihař 01 Feb '11

01 Feb '11

Hi all when going to other page, browsers sends Referer header to the next server. This could obviously leak some information from the original website. Given that we might include in URL possibly sensitive information (eg. SQL query), I've added redirector (url.php) inside phpMyAdmin, what hides all the parameter and all what the next site can see is <PmaAbsoluteUri>/url.php?url=<URL where you go>. On the other side, user might want to hide <PmaAbsoluteUri> as well. This can be only achieved by using some external redirector, for example we could place one at phpmyadmin.net. Any opinions about that? PS: The referrer should not be sent when original site is using HTTPS, quoting RFC: > Clients SHOULD NOT include a Referer header field in a > (non-secure) HTTP request if the referring page was transferred with > a secure protocol. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

4 9

[Phpmyadmin-devel] AllowArbitraryServer and synchronisation
by Michal Čihař 31 Jan '11

31 Jan '11

Hi all for security reasons we have chosen AllowArbitraryServer to be disabled by default. On the other side we have synchronization feature which allows to connect to arbitrary server as well and fetch any data from it. I think this disproportion should be fixed. I can see two approaches: 1. The other option would be to drop AllowArbitraryServer completely as right now it really does not bring any security. 2. Make AllowArbitraryServer really work as expected: - Make AllowArbitraryServer enabled by default. I don't think the risk is too big and many people would use this feature. - If AllowArbitraryServer is set to false, disallow synchronization with arbitrary server as well. But maybe I'm missing some other possibility. Comments? -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 3

[Phpmyadmin-devel] GSoC 2011 idea : Zoom-search
by Marc Delisle 31 Jan '11

31 Jan '11

(sorry if this comes up as a double post) Hi, I just added a new idea: http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#Zoom-search -- Marc Delisle http://infomarc.info

1 0