Re: [HACKERS] Have people taken a look at pgdiff yet?

> > A diff utility with a mandatory GUI frontend through a webserver is
> > positively the most bizarre thing I have ever heard of.

This may be true of a file diff utility but for a dbms diff utility there is
sometimes ambiguity and pgdiff attempts to be more than just a diff utility.

pgdiff allows you to select your database source and target from existing
dbs,
schema files or merely text box input for schemas. It then displays summary
of
the schemas by table, index, seq, etc. You can then examine / modify /
insert
the diff script for each subdb entity type. You can test your diff scripts
and
likewise examine in detail the results. If the results were not what
expected
you can go back and modify the scripts or delete portions. Basically pgdiff
attempts to be a schema comparison utility in adddition to diff script
creator.
This is one of the main reasons for the GUI aspect of it. By having this
comparsion functionality you get a much better idea of what your scripts
will
do before really applying them. pgdiff does all aterations on a test db
which is
a clone of the orignal schemas so no harm is done using/testing with pgdiff.


>No, AOLserver is just that good at database connectivity.... :-)  And it
>makes
>a great development environment for various db utilities.

Hopefully the above are some reasons why to have a gui and the quote above
is
the summary for why to make it webserver frontended. It saved a lot of work
by using the functionality available within AOLserver. Also it allows a demo
of the utility to be offered online so people can get a feel for what/how it
does it work at www.23pools.com:8000

At some point in the future  I plan to take the code and create
a striped down version that is command line only but I don't have the time
currently but the source is at sf so have at it.

Best Regards,
Carl Garland

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail