Hello everyone,
I am back with my small crazy Idea! I think a Drag-n-Drop database creation
feature(Something Similar to MySql Workbench) would be a very good idea
implement as a part of new UI. PMA could be next Workbench Killer, if
implemented properly. I tried to implement drag-n-drop using JqueryUI and
did get some initial success. Since PMA is going to get a facelift, i think
this feature is a must. Right now, my code can add a database and a table to
the database using drag-n-drop (Not using PMA). There are a few UI bugs,
removing which i'll upload the code.
I do hope my idea gets implemented as it'll be a revolutionary change in the
way a database is created using PMA.
Thank You,
Vipin Nair
nair.vipin(a)ymail.com
swvist(a)gmail.com
hi
I am Akash Nawani, student of Computer Science and Engineering
from Institute of Technology, BHU, India.
I want to contribute to phpMyAdmin as a GSoC 2010 student. I am interested
in doing project named "Charts in server status page".
I have been using phpMyAdmin since last 2 years and have a good knowledge of
PHP and MySQL.
I have also used GD2 for drawing graphs.
I would like to hear your opinions about this project so that I can start
with it.
Regards,
Akash
Hi,
I am a student at the University of Moratuwa, Sri Lanka and I have 2 years
experience working with PHP and MySQL. During this time I have made use of
phpMyAdmin during all my projects involving MySQL and database management,
therefore I would like to give something back to phpMyAdmin in the form of a
GSoC Project.
The project idea that interested me the most was 'cleaning up the interface'
idea. I went through the feature requests that have been posted with regard
to this idea, and I think I could manage to provide these requirements. It
would also be interesting if I could collaborate with whoever is taking the
'AJAX for the interface' project and complete both projects as a combined
effort.
e.g. A feature that could be provided on the interface via AJAX could be,
when the mouseover event is triggered on a specific database's name, a drop
down Javascript list could be generated which would allow the user to select
a specific table for viewing.
Hope to hear your feedback on this.
Thank You!
--
Yours Truly,
Ramindu Deshapriya.
Hi all.
I came across the project idea of improving the UI of phpMyAdmin. As a user,
I wanted a lot of improvement myself since I deal with large databases and
the current UI slows down my work by a great deal. I have been using JQuery
for more than a year now and I've become pretty good at it. I was wondering
if one could use JQuery entirely for to make the front end resemble MySQL
Query Browser, an application that I use a lot for my database work when
there are no 3306 firewalling issues. Please do let me know if I can proceed
with this idea for my Google SoC application.
Regards.
Meher Anand
4th Year
Department of Computer Science & Engg.
Visvesvaraya National Institute of Technology
Nagpur, India
Hi, I am Lee Sing Jie from National University of Singapore, doing
Computer Engineering. As the term engineering derives, I have
experience in both software and hardware coding. In school, I have
done assembly language, C, C++ etc. Out of school, I offer freelance
web eCommerce solutions. I have setup multiple online shops for new
businesses, so PMA is of no stranger to me. Many of the old catalogs
system I implemented are fully coded by me.
During this GSOC, I am interested in contributing to PMA by developing
Charts in server status page.
Shortly, I will try to pick up some of the bugs in the tracker and try
to merge myself into this PMA development sting.
I hope I can do my part to the open source community and of course to PMA.
Regards,
Sing Jie
Hi
I want to complete PMA User interface cleanup project for GSoC 2010.
I am working on the implementation part of it and will surely brief the
concerned persons about it soon.
For now, I just had a doubt that if I can co-ordinate with the OOP PMA
project people, that would make
the new PMA far more better according to my approach, please let me know if
that is possible.
Himanshu Bansal
Sophomore
BITS Pilani Goa Campus
Hi Everyone!
I am Sumesh ks, From India.
I am currently pursuing Master of Computer Application at Govt. Engineering
College (RIT), Mahathama Gandhi University, Kerala.
I have been programming and developing applications for about 2 years, and
programming has always been a passion. I love a mix of large projects and
programming contests to keep the adrenaline running!
I haven't contributed to any opensource project, But have developed web
based or desktop applications for internal purposes at my college or for
hobby. Have worked on windows and linux platforms, languages and strong in
software design and quick implementation.
I have good knowledge in C,C++,PHP,MySQL.and also have good experience in
Adobe Photoshop,Flash, Iam using phpmyadmin for 2 years for my web
development projects.
I read your ideas for Google Summer of code 2010. i am interested in working
"User interface cleanup". I read the feature request mentioned in the idea
list and i like to work on that.Feature requests: rfe:1714760, rfe:2649375,
rfe:1494550, rfe:735925.
Thanks and regards,
Sumesh ks.
Hello,
It's a great thing that phpMyAdmin is part of the GSoC this year!
I presented myself some weeks ago, then discussed with Marc about some ideas on this project. Now I'm submitting these to all the developers.
Ideas on some this project
- Separating the presentation tier from the logic tier (currently in discussion on the devel mailing list). Moreover, no presentation layer should be present in the libraries' modules. All presentation related files (header_*.inc.php and footer.inc.php) would leave the /libraries dir.
- In the PMA library, OO written modules could be loaded using PHP's autoloading capacities. Folders should be used to help organize the librairies folder, to restrict the number of files directly within /librairies and enforce modularity in the library structure.
- Every file that's present two or three times and more with the same namespace (server_*, select_*, tbl_*, pmd_* ...), both from / and /librairies could be grouped and namespaced in one or more static methods, to benefit from autoloading, decreasing the amount of file and the require/include to write. Files used directly in the presentation layer (as server_* in /), once class transformed, would be queried from the logic tier for the presentation tier, should a template system be adopted.
- All export and import related files (/libraries/export/* and /libraries/import/*)could be merged in an Export and an Import modules. These modules would offer a uniform interface to ensure that third parties and vendors file format implements the methods PMA needs to interact with to send and retrieve data, and are object oriented. This could simplify the addition of new export/import format by third parties/companies. Moreover, third parties libraries (such as tcpdf or PHPExcel) should be located within their related module directory and not directly under /libraries. Before that, existings export/import libs have to be rewritten in OOP to be compliant with their own module interface.
- Libs like common.lib.php have too much and various responsibilities (and responsibilities from other layers). Without stepping directly into OO code, these files could be breaked in more specifics libs. Obviously, a 'common' named file contains common functions, but I think it's too much functions in a single file.
For exemple, common.lib.php = 2771 lines. math functions, mysql functions, 'templating' function, escaping functions, formatting functions, navigation functions, messaging function (PMA_showMessage has ~260 lines, big for a single function, too many responsibilities), date functions, pagination, cache management (that one could get its own class).
- Global vars and objects access. Sometimes 'global' keyword is used between related functions, most of the time it's $_GLOBALS, and I could bet that I saw a Registry somewhere, but can't get my hands on anymore. What are the rules you observe concerning the global namespace ? $_GLOBALS for now and Registry for later ?
I also checked the Feature Request on the tracker, but most of the suggested features are not "OO code" oriented.
I am open to discussion on every ideas above, and even more !
Regards,
Edouard