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