- Developers - lists.phpmyadmin.net

Re: [Phpmyadmin-devel] copy db with view of a view
by Dieter Adriaenssens 30 Mar '10

30 Mar '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Marc, -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Use GnuPG with Firefox : http://getfiregpg.org (Version: 0.7.10) iEYEARECAAYFAkuxDfMACgkQZGJbiPqZM6OoygCdGqPfYLDfG8t8YgRW0UffUk/2 4DQAn0IbtnU/woKO4AbMw4+QvPnL8E7L =WhiA -----END PGP SIGNATURE----- 2010/3/29 Marc Delisle <marc(a)infomarc.info>: > Dieter Adriaenssens a écrit : >> Someting else : I found a broken link to Devel:Git on the FAQ page ( >> http://www.phpmyadmin.net/documentation/#faq7_3 ) >> ' our wiki' now links to >> >> 'http://wiki.phpmyadmin.net/pma/Devel:git' >> >> but it should be : >> >> 'http://wiki.phpmyadmin.net/pma/Devel:Git' >> >> Can I change this myself? I noticed the website is in git, but I was >> wondering : if I change it in git, is it automagicaly updated on the >> webserver, or is there a manual action needed? > > Please change it yourself in QA_3_3 and merge to master. Magic will happen > to update http://www.phpmyadmin.net/documentation/Documentation.html#faq7_3 > from master. I've done something wrong I guess : I was looking for the Documentation.html file in the phpmyadmin/website project, but couldn't find it. Eventually I came across it in the localized_docs project, and changed the file, but it turns out to be in the output folder, so it will probably be overwritten next time the documentation is generated. Should I have modified all the files in the po folder? What about the files in the pot directory? Or am I changing it in a complete wrong place/way? Thanks for clarifying. Regards, Dieter

3 3

[Phpmyadmin-devel] git and $Id$ expansion
by Marc Delisle 30 Mar '10

30 Mar '10

Hi, with our switching to git that will happen just after the 3.3.0 release, I guess we should remove this line from all files: * @version $Id$ -- Marc Delisle http://infomarc.info

3 7

[Phpmyadmin-devel] Student application : no rush please
by Marc Delisle 30 Mar '10

30 Mar '10

Hi, The student application period is from March 29, 19:00 UTC to April 9, 19:00 UTC. As an advice to students, please do not rush to send a proposal. In particular, you really want to put in your proposal links to our Patches tracker where you submitted phpMyAdmin code modifications. Remember, we cannot guess your SourceForge.net user name so links will be clearer. -- Marc Delisle http://infomarc.info

3 3

[Phpmyadmin-devel] PMA related question to Mr. Delisle
by Nissim Salinas 30 Mar '10

30 Mar '10

Hi Marc, I would like to send you a few screen-shots in jpg format, of a proposed theme and layout. I know that [a] your email scrubs attachments, and [b] it's better not to email you directly. So, how do I send you a zip with a few jpg's and a text or rtf file explaining the design and asking a few questions? Thank you in advance for your answer. Best Regards, Nissim nmsalinas(a)yahoo.com

2 1

[Phpmyadmin-devel] GSoC AJAXifying phpMyAdmin with jQuery
by Emily Brand 30 Mar '10

30 Mar '10

Title: AJAXifying phpMyAdmin with jQuery Name: Emily Brand Location: Chicago, CST I will use jQuery to essentially make 90% of the administration ajax-style so that not as many reloads will have to occur throughout the site. Speed is quite a problem in phpMyAdmin at the moment, especially while running locally (at least on my computer). I am proposing not only switching the top navigation menu over to jQuery, but also editing table structures, searching tables, building queries, inserting new fields and new rows, and much more. I will also allow the site to degrade nicely if a user does not have javascript enabled. I am planning on converting the following features to AJAX-style coding: Top Navigation Bar Adding Fields to tables Validating the inserted fields Inserting/updating rows in tables Search Function Query Builder Function primary/unique/index keys Empty/Drop/Delete Does anyone have any more suggestions of things I can add to my timeline? Thanks! Emily Brand eabrand(a)gmail.com http://linkedin.com/in/emilybrand

2 1

[Phpmyadmin-devel] Introducing my idea for GSoC
by Цоло Цолов 30 Mar '10

30 Mar '10

I am writing with hope that I will get your forgiveness for sending this introduction as a GSoC candidate so late. My name is Tsolo Tsolov and I'm a Bulgarian "TECHNICAL UNIVERSITY OF SOFIA" student with about 3 years of experience in professional web development. My experience is mainly in modifying and creating plugins for CMS. In the beginning of my PMA experience it was pretty hard for me, because I get really confused of the great various of the interface options. And from there came my idea: It is about making a “lite” interface for inexperienced users. My idea about the Lite version is to have its own folder called “lite” and to use as much as possible the PMA source. The possibilities in this interface will be only the basic ones that will be useful for the beginners. The other idea that I have and I can attach like a patch (in early version) is DHTML tree menu for the navigation frame. The tree menu will have easy CSS template styling and functionality to group tables by prefix. Please give me your opinion about that interface, because I am really keen on its development even if it’s not for the GSoC program. Best regards Tsolo Tsolov

3 2

[Phpmyadmin-devel] GSoC 2010 : Charts in server status page
by Neeraj Agarwal 29 Mar '10

29 Mar '10

Hello Everyone, I have been using phpMyAdmin a lot for my development work on PHP/ MySQL and it really fascinates. It creates such a simple interface for regular people to manage their database. I very much liked the idea of server status page for PMA. Using GD2 library (PHP) would be the most convenient option. We can build graphs for volumes, errors, traffic inflows, server downtime due to high volume, highlight server alerts, breakdown, etc Anybody here to discuss the idea? ------ Regards, Neeraj Agarwal

3 15

Re: [Phpmyadmin-devel] Revamping phpMyAdmin to utilize MVC architecture
by Aaron Maturen 29 Mar '10

29 Mar '10

Here's the current version of my proposal, just wondering what people's thoughts are. Thanks everyone Aaron Maturen Revamping phpMyAdmin to utilize MVC architecture Name: Aaron Maturen Location: Saginaw, Michigan, United States of America ( GMT -5 ) Education: Pursuing BS in Computer Science & BA in French Email : atmature(a)svsu.edu Website: http://www.aaronmaturen.com Synopsis: My proposal is to rewrite the architecture of phpMyAdmin with the model-view-controller(MVC) design pattern. With this pattern we will be able to separate all the code into three parts: The Model. This is where the business logic goes. All the code to connect to the database resides here. If we code the adapter pattern here we could potentially give PMA the ability to work with other RDBMS with simple plugins. The View. This is where the template system goes. Implementing a complete template system and recreating themes for PMA is beyond the scope of the The Controller. Links the Model(all the data) with the View(what the user sees) Additional Design Patterns that could be implemented: Singleton: For handling sessions. makes sure that there is only ever one instance. Strategy: For handling languages. allows different languages/themes to be easily interchanged. Prototype: For handling the presentation system. Consists of concrete forms of presenting data for example; html, csv, pdf, svg, etc. We can easily add an AJAX library into this to allow the MVC framework to utilize AJAX and be able to transfer data between the classes without a page refresh. Although it would be useful to have an AJAX library in the code, utilizing it for most things would be out of the scope of this proposal. Benefits to the users: The MVC architecture will better support scalability and ease modification and maintenance(due to the separation of tasks). Also with the template system and business logic located in separate files comes the separation of the front and back end of the website; resulting in a more robust website. The separation of the design and applications layers allow for increased levels of interactivity without compromising security. By using MVC Architecture and working in an Object oriented format, the website becomes increasingly modular where users can easily add new modules without disturbing the rest of the application. Project Details: A more detailed description. Deliverables: What will be the final output from your project? Project Schedule: Week I (and before) - Start Breaking down phpMyAdmin into logical groups and design patterns. Publish my goals to PMA listserv and get feedback on my plans. Week II - Continue to break current code down in design patterns. Implement the MVC skeleton and start to implement user system. Week III - Language system. Implement strategy pattern to allow for localization. Since this is done before any text gets typed to be displayed we won't have to go back and re-implement it. Week IV - Database Connection/Manipulation. Start to implement talking to the database using the adapter and porting the existing code Week V - Continue Database porting. Week VI (MIDPOINT) - Implement template system. Week VII - Have MVC completed with all current functionality restored. Week VIII - Work on the presentation data to allow for different presentation modes: ie) web, print Week IX - Test current version. Finish any part needed for soft finish that ran behind. Week X - Soft Finish. Leave last 2 weeks for tweaking the application and fixing bugs. Week XI - Tweak App, Fix Bugs. Week XII (END) - Finish. Time: My only commitment this summer is my job at Audio Central Alarm in Saginaw, Michigan where I work as a dispatcher. Normally this entails sitting in front of a computer for 8 hours on third shift getting paid to do my homework. This summer I am not planning on taking any spring/summer courses so I am able to devote 50+ hours a week to this project. Bio: I started programming HTML in 2001 when I was in 7th grade, my friend got me interested in it. From there I kept trying different things; in 8th grade I vaguely remember dabbling with Java. When I got into high school in 2002 I joined the FIRST Robotics team and that first year I was on the animation team. After that year the only student who knew how to program was graduating so I sat down over the summer and learnt pBasic, a version of Basic for the Parallax BASIC stamp microcontroller. But, I never got a chance to use it. Soon as the next season started up they announced that they had switched controllers to Microchip’s PIC controllers, which were programmed in C instead of being programmed in pBasic. I continued to spend the remaining three years on the FIRST Robotics team programming in C. During this time I was also part of the Lemelson-MIT InvenTeam from my school where I programmed a vector-based autonomous field striper, and created a Socio-economic model for robots to follow which took 4th place at the Intel International Science and Engineering fair for team Projects. But, even though I spent a lot of concentration on those projects thats through High School it was around this time that I started diving deeper into web programming with MySQL, PHP, and CSS. And I’ve been playing with it since then. Experiences: Recently I have been working on my own website using MVC architecture. It started out as a bet from my friend that I couldn’t make a site similar to facebook in a week. I did that but he argued that even though I had classes in my design that it wasn’t object-orientated. This inspired me to evolve the site to the next level with MVC architecture and design patterns. While its still and progress the site can be viewed at http://www.zoebabin.com and the source code for it can be found at http://www.aaronmaturen.com/mvc.zip. I have been using PHP and MySQL for 6 years now and I’m always trying to expand my knowledge on them. Currently I am studying for my MySQL 5.0 DBA certification which I am hoping to have by May. Also during this last semester I helped run a study group on design patterns where we went through the Gang of Four book and the Headfirst into Design patterns and went over 3 of the design patterns every week. Also I am currently working on a research project with biology professor, Dr. Gary Lange and a fellow student at Saginaw Valley State University where we are designing a program to record events in controlled lab experiments. We’re using Java to program it in order to ensure that the program will be able to be ported easily to several different operating systems. In regards to programs I have done for class; my favorite one was coding Dijksta’s shortest path algorithm into a flight management system. It was with this program that I was able to become the most comfortable with the standard template library in C++. Open source: In preparing for Google Summer of Code for 2010 I started looking at projects that have been part of it in the past; mainly XBMC. I got as far as using svn to copy the trunk and install all of the dependancies for it to be compiled, but unfortunately before I was able to complete any pre-qualification tasks the projects were announced and XBMC isn’t one of them.

2 3

[Phpmyadmin-devel] User Interface Redesign (GSoC)
by Lori Lee 29 Mar '10

29 Mar '10

Hi everyone, I'm an undergrad in Human-Computer Interaction at the University of Toronto and am very interested in improving the usability of the PMA interface as a GSoC project. I have been looking through the list of feature requests and taking some of them into account when considering what changes could be made. I'm wondering if it would be beneficial to include an explanation and mock-up of the changes I would like to make as a part of my proposal. If anyone has any other comments or suggestions about this idea, I would love to hear them. -- Thanks, Lori

2 1

[Phpmyadmin-devel] js caching and the ?ts parameter
by Marc Delisle 29 Mar '10

29 Mar '10

Hi, in libraries/header_scripts.inc.php all the loading of .js adds the timestamp of the file as a parameter. This produces in my Apache log file a 304 request for each file. It's true that the .js file itself is not transmitted but couln't we avoid those requests? Maybe it's intended for developers who don't want to remember clearing their browser cache, more than for users? -- Marc Delisle http://infomarc.info

2 1