GSoC Student

Hi everyone
Sorry for this late mail, i should have introduced my self earlier. Any ways here i go..Well i am one of the student selected for GSoC this year and had floated a proposal on a new feature about PgAdmin and would now be creating it under the mentorship of Dave. This is my first time to GSoC and its a great feeling to be part of this community because of it. I hope to learn a lot from you all and would be pinging you for the help that i might require.I am thankful to Dave about his apt suggestions regarding the proposals and the questions he raised.

So whats the project, here is the project abstract.
"The idea is to make enhancement to pgAdmin,which would provide the user with an intuitive graphical comparer and a synchronizing feature. The user could know difference between two selected database(objects), and this would enable user to visualize the comparison (structural) before applying(synchronizing) the generated difference on the source/target db's or at both ends. This feature would enhance the developer/dba ability to not only apply all changes to the production environment with just few clicks, but to be sure what would happen to the data base in question. User could also apply selective changes. This would remove users from the existing way of data script creation and application which is both tedious and boring and is less flexible."

Currently i am looking to just make the the said thing for schema, and even further trimming the scope by making this for few objects eg table,views, columns,data type, constraints etc. This would help the user see the schema difference at both ends(source and destination) plus would show him/her the possible changed schema after the applied change.This is just for GSoC, but this is just the beginning, it has to be taken to the next level and to make a difference visualizer for data. One can see such a thing in a proprietary products (at least seen one), then why not make it for PgAdmin and hopefully in a better way.
I 'am more interested in to make it as intuitive and user friendly as possible, instead of a person using command line tools to apply difference. It's like a tool just like Tortoise SVN to show the difference and help ones apply the patch, if there are any conflicts (only comes in a 2-way synch) resolves it or else. It is much handier tool than a command line version, which could be powerful but demands probably more attention.
Here is the link for the screen shots about my idea.
http://sites.google.com/site/loaderboot/ideasscreenshots

In the end, i would say its just a beginning and its a long road and i would be surely looking forward for you suggestions, comments or else and obviously help.

take care
adeel