- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Git is here
by Michal Čihař 24 Mar '10

24 Mar '10

Hi all I should have announced it earlier (as the repository migration went as planned), however I somehow got focused to migrating other tools meanwhile so the announcement comes now. So yes, everything is in Git now and the Subversion repository is in read-only mode. Please check if something is not broken, I might have missed something. Things which should work without problems: - demo server - daily snapshots - website, translation stats,... - creating releases [1] For using Git, please follow instructions in wiki [2]. Especially working properly with more branches can save you lot of work. [1]: As I added there some improvements, I also started documentation for release process (which is far from being complete right now) on wiki: http://wiki.phpmyadmin.net/pma/Devel:Releasing [2]: http://wiki.phpmyadmin.net/pma/Devel:Git -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 14

Re: [Phpmyadmin-devel] Proposal for GSOC 2010.
by Hemanth kumar 24 Mar '10

24 Mar '10

Hi, I'l submit my proposal formally on march 29. Regarding Exporting it to XML format what i intended to say was i want to exporting whole database into XML format with one click. I've an idea on how to do it. MySQL supports converting sql query result into XML and Mysql also displays complete list of tables using "show tables;" We have to merge both the features. I Dont know if its extensively useful but as an admin UI i want to provide all the features. Thanks & Regards R Hemanth Kumar Date: Tue, 23 Mar 2010 14:25:39 -0400 From: Marc Delisle <marc(a)infomarc.info> Subject: Re: [Phpmyadmin-devel] Proposal for GSOC 2010. To: phpmyadmin-devel(a)lists.sourceforge.net Message-ID: <4BA907A3.2040602(a)infomarc.info> Content-Type: text/plain; charset=UTF-8; format=flowed Hemanth kumar a ?crit : > Hi , > > I'm Hemanth,Undergrad Student of Bits-Pilani Goa campus-INDIA. I would > like to work on GSOC project USER INTERFACE CLEANUP. > > Last semester i developed an intranet application using php, Mysql, I > used phpMyAdmin for it and i feel there should be some changes in the > user interface and i would like to share my suggestions for phpMyAdmin > user interface cleanup. > > 1. User should be able to customize the user interface of phpMyAdmin. > Example: user should able to hide unwanted Links. > OR > Less used links should be under one link moving cursor upon it drops > down a menu of less used links. > > 2. GUI should be Made simpler for Novice or There should two instances > of phpMyAdmin one for Basic users and other for Advanced Users. Hi, these are interesting points that you can put in your formal proposal, when Google's interface accepts proposals on March 29. > > Recently I worked on php, XML, MySQL and i noticed phpMyAdmin doesn't > have a feature which converts result of a SQL query to XML format which > can be used for taking backup of data. In phpMyAdmin 3.3.1, in table Export you can export in XML. Did you try it? > > I would like to work on the above as GSOC 2010 project. -- Marc Delisle http://infomarc.info -- R.Hemanth Kumar Bits-pilani Goa campus Msc Economics+B.E. (hons) Chemical engineering

1 0

[Phpmyadmin-devel] Proposal for GSOC 2010.
by Hemanth kumar 23 Mar '10

23 Mar '10

Hi , I'm Hemanth,Undergrad Student of Bits-Pilani Goa campus-INDIA. I would like to work on GSOC project USER INTERFACE CLEANUP. Last semester i developed an intranet application using php, Mysql, I used phpMyAdmin for it and i feel there should be some changes in the user interface and i would like to share my suggestions for phpMyAdmin user interface cleanup. 1. User should be able to customize the user interface of phpMyAdmin. Example: user should able to hide unwanted Links. OR Less used links should be under one link moving cursor upon it drops down a menu of less used links. 2. GUI should be Made simpler for Novice or There should two instances of phpMyAdmin one for Basic users and other for Advanced Users. Recently I worked on php, XML, MySQL and i noticed phpMyAdmin doesn't have a feature which converts result of a SQL query to XML format which can be used for taking backup of data. I would like to work on the above as GSOC 2010 project. Thanks and Regards -- R.Hemanth Kumar Bits-pilani Goa campus Msc Economics+B.E. (hons) Chemical engineering

2 1

[Phpmyadmin-devel] phpMyAdmin OOP
by harsh gidra 23 Mar '10

23 Mar '10

Hello everyone, I am Harsh Gidra, an undergraduate student studying in National Institute of Technology, Jaipur, India. I am familiar with PHP and MySQL and have developed a number of projects involving these technologies. I want to work on porting the code into an clean OOP structure as mentioned in http://wiki.phpmyadmin.net/pma/GSoC_2010_Ideas_List -- Thanks and regards, Harsh Gidra http://gidraharsh.in

1 0

Re: [Phpmyadmin-devel] GSoc 2010 - Charts in server status page
by Madhura Jayaratne 23 Mar '10

23 Mar '10

>> Hi everyone, >> >> My name is Madhura Jayaratne and I am an undergraduate from the >> University of Moratuwa Sri Lanka. I have few years of experience in >> using php and mySql and was a user of phpMyAdmin for few years. >> >> When I was going through the GSoC idea list I noticed the project idea >> on charts and was interested as I have engaged in developing a general >> charting framework during my internship. I went through the requested >> feature list and had a look at the area of the codebase where I have to >> do the development. >> >> I have few ideas to add in this regard. My feeling is that, before >> adding charts to the runtime information tab we should put in place a >> framework that would allow us to extend charting facilitates wherever we >> want to have it in phpMyAdmin. >> >> What I'm proposing is a general data structure that would facilitate >> multiple types of charts (we can learn a lot from Google Visualization >> API in this regard), and a set of interfaces that would facilitate >> different implementation for different chart rendering engines( we can >> even go for something other than CD2, if we feel like that sometimes >> down the line) >> >> Though this would take few weeks of extra time, I feel that this allows >> a lot of extensibility. When we have this framework in place we can do >> the implementation as for the requirement we have now and we can go on >> to add different charts to phpMyAdimn in the future as the requirement >> arises. >> >> Would love to hear your opinion about this >> >> Thanx in advance >> >> Regards, >> -- >> Madhura Jayaratne > > Are you thinking about a js framework (producing the charts on the > client) or a PHP framework (running on the server). > > -- > Marc Delisle > http://infomarc.info <http://infomarc.info/> > > > What I had in my mind was a PHP framework running on the server. > What do you think about that? > > Regards > -- > Madhura Jayaratne We'll have to see. Please read this list's archives for past discussions a few weeks ago about templating and PHP frameworks. -- Marc Delisle http://infomarc.info Sure, I'll do that and post to the forum if I have any further queries regarding templating and PHP frameworks. Thanx and regards -- Madhura Jayaratne

1 0

[Phpmyadmin-devel] Charts in server status page
by Akash Chauhan 23 Mar '10

23 Mar '10

Hi my name is Akash Chauhan , and I am a 3rd year student of National Institute of Technology Trichy India, also I am member of development team of a project called connectnit.org which connects all the NIT's at one place, also I am member of my college's webdesigning team. I am interested in GSOC 2010 . As having good experience in php and mysql i was happy to see PMA in it ,when I was looking at the ideas of PMA and I am interested in the idea CHARTs for server status using GD2 and would like to contribute for the same. I will be updating all my works at my blog http://connectnit.org/blogs/cipher/

1 0

Re: [Phpmyadmin-devel] [Phpmyadmin-users] phpMyAdmin wont start
by Dieter Adriaenssens 23 Mar '10

23 Mar '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 2010/3/23 ayman bs : > I do apologize Marc, I thought Gmail will automatically choose the mailing > list address. > Jim, Usually the "it works" problem comes when you point your browser to a > proxy server... > > Check it. A default Apache install (in debian/Ubuntu) puts a html-file in the webroot, with the message 'It works!' as well. ;) It's just a message telling you that your webserver was installed and configured correctly, and is up and running. Greets, Dieter > > On Tue, Mar 23, 2010 at 1:04 PM, Marc Delisle wrote: >> >> ayman bs a écrit : >>> >>> Usually the "it works" problem comes when you point your browser to a >>> proxy server... >>> >> >> I am not the one who has this problem. Please reply to the list. >> >>> >>> >>> >>> On Tue, Mar 23, 2010 at 11:28 AM, Marc Delisle >> > wrote: >>> >>> Jim Weidner -- K2JXW / ARLHS a écrit : >>> > I downloaded and installed XAMPP, >>> > The control box says that MySQL and Apache are running. >>> > I enter http://127.0.0.1 and get the return "It works." >>> > I type http://localhost and get the return "It works." >>> > I type http://localhost/phpMyAdmin and get nothing -- can't find >>> it >>> > How do I get phpMyAdmin to run? >>> >>> Hi, >>> "It works" is not the usual output from XAMPP. You should get an >>> orange >>> page with menus, in which you would see a link to phpMyAdmin. Please >>> seek support from XAMPP forums. >>> >>> Also, I believe that the link should be http://localhost/phpmyadmin in >>> XAMPP but I might be mistaken. >>> >>> -- >>> Marc Delisle >>> http://infomarc.info >>> >>> >>> - ------------------------------------------------------------------------------ >>> 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-users mailing list >>> Phpmyadmin-users(a)lists.sourceforge.net >>> >>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users >>> >>> >> >> >> -- >> Marc Delisle >> http://infomarc.info > > > ------------------------------------------------------------------------------ > 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-users mailing list > Phpmyadmin-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users > > - -- Groetjes, Dieter Adriaenssens -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.12 (MingW32) Comment: Use GnuPG with Firefox : http://getfiregpg.org (Version: 0.7.10) iEYEARECAAYFAkuo0MAACgkQZGJbiPqZM6MflgCgkw7SsB91d8qf4/20CQwF3afr pgoAn2Nvpg9xMCdxTh1f20fkbFvavWNE =QnJr -----END PGP SIGNATURE-----

3 3

Re: [Phpmyadmin-devel] GSoc 2010 - Charts in server status page
by Madhura Jayaratne 23 Mar '10

23 Mar '10

> Hi everyone, > > My name is Madhura Jayaratne and I am an undergraduate from the > University of Moratuwa Sri Lanka. I have few years of experience in > using php and mySql and was a user of phpMyAdmin for few years. > > When I was going through the GSoC idea list I noticed the project idea > on charts and was interested as I have engaged in developing a general > charting framework during my internship. I went through the requested > feature list and had a look at the area of the codebase where I have to > do the development. > > I have few ideas to add in this regard. My feeling is that, before > adding charts to the runtime information tab we should put in place a > framework that would allow us to extend charting facilitates wherever we > want to have it in phpMyAdmin. > > What I'm proposing is a general data structure that would facilitate > multiple types of charts (we can learn a lot from Google Visualization > API in this regard), and a set of interfaces that would facilitate > different implementation for different chart rendering engines( we can > even go for something other than CD2, if we feel like that sometimes > down the line) > > Though this would take few weeks of extra time, I feel that this allows > a lot of extensibility. When we have this framework in place we can do > the implementation as for the requirement we have now and we can go on > to add different charts to phpMyAdimn in the future as the requirement > arises. > > Would love to hear your opinion about this > > Thanx in advance > > Regards, > -- > Madhura Jayaratne Are you thinking about a js framework (producing the charts on the client) or a PHP framework (running on the server). -- Marc Delisle http://infomarc.info What I had in my mind was a PHP framework running on the server. What do you think about that? Regards -- Madhura Jayaratne

2 1

[Phpmyadmin-devel] JQuery AJAX Implementation - Google SoC
by Meher Anand 23 Mar '10

23 Mar '10

Hi. I've tried to come up with a method that will help the UI experience for the user through AJAX while degrading gracefully for non Javascript supporting browsers. So here it goes: Ajaxifying the Browse table interface: 1) Currently clicking on the Delete icon causes a Javascript alert and then a page refresh takes place. Instead of refreshing, we can have a $(this).parent().parent().hide() called and at the same time, send a request to sql.php to make the deletion. 2) Currently clicking on the Edit icon causes a new page to open and changes must be made and saved there. We can associate the double click event of JQuery (.dblclick) with each of the fields inside a row so that when one would double click on a field in the row, all fields in the row turn into text boxes where changes can be made and once the focus is removed, the text boxes can become text fields again. Once a user decides to commit all changes, he would click the 'Submit Changes' button and he would receive the status update regarding the changes in the table. 3) A similar method can be employed to implement the Add row feature in Ajax. These are the ideas that I could come up with right now. The best part about this is, one need not be concerned about majority of things while writing the Javascript code. One can see that if Javascript is disabled, the application would run how it would have normally run otherwise. Also, there is a team that is working on GUI improvement. Their work can be run independently of this and very minor changes would have to be made in order to accommodate the JQuery Ajax code into the improved application. Please review this idea and let me know if you have any questions regarding the same. Regards. Meher Anand

3 6

[Phpmyadmin-devel] Can this be a GSoC project for phpMyAdmin?
by Edvard Ananyan 23 Mar '10

23 Mar '10

Hi, As you may already know Joomla! didn't participate in GSoC this year. Last year I was a GSoC student doing a project for Joomla: http://jwcp.googlecode.com/ Here you can find my last year's proposal: http://edo.webmaster.am/proposals/11 This year I want to extend it and make possible to select tables from the database which can be kept under revision control with the help of mysql triggers. Currently in Working Copy I'm using a "spy" implemented with mysql triggers which can log the changes made on the table. What do you think can the versioning of mysql tables become a project for phpMyAdmin? Regards, Edvard

2 5