Have people taken a look at pgdiff yet?
Hi everyone,
Just found out that the "pgdiff" utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:
http://sourceforge.net/projects/pgdiff
Have people already looked at this?
:-)
Regards and best wishes,
Justin Clift
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi
On Tue, 7 Jan 2003, Justin Clift wrote:
Hi everyone,
Just found out that the "pgdiff" utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:http://sourceforge.net/projects/pgdiff
Have people already looked at this?
I started... but had to install and configure AOLServer, which took more
time than I had allotted to thie experiment. I never was able to get a
diff to run. I think a good pratical and working example is needed for
that utility. I'd like to see how it works.
Justin Clift writes:
Just found out that the "pgdiff" utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:
A diff utility with a mandatory GUI frontend through a webserver is
positively the most bizarre thing I have ever heard of.
--
Peter Eisentraut peter_e@gmx.net
On Tuesday 07 January 2003 12:40, Peter Eisentraut wrote:
Justin Clift writes:
Just found out that the "pgdiff" utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:
A diff utility with a mandatory GUI frontend through a webserver is
positively the most bizarre thing I have ever heard of.
No, AOLserver is just that good at database connectivity.... :-) And it makes
a great development environment for various db utilities. Although the
pgdiff people might should mention the need on their summary page....
I've heard of more bizarre things, though.....
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
I second that, if that is the case....
Peter Eisentraut wrote:
Show quoted text
Justin Clift writes:
Just found out that the "pgdiff" utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:A diff utility with a mandatory GUI frontend through a webserver is
positively the most bizarre thing I have ever heard of.
I'm busy trying to set up AOLserver to access PostgreSQL. Can you offer any
advice on what driver to use (docs aren't entirely clear on the virtues of
the internal PostgreSQL driver vs. the ARSdigita driver and it looks like the
ARSdigita is being merged into the AOLserver code but that's in a beta state
- a bit of a headache for an AOLserver newbie).
Cheers,
Steve
Show quoted text
On Tuesday 07 January 2003 10:02 am, Lamar Owen wrote:
On Tuesday 07 January 2003 12:40, Peter Eisentraut wrote:
Justin Clift writes:
Just found out that the "pgdiff" utility (the one for comparing two
different PostgreSQL database's) was released and uploaded to
SourceForge in November:A diff utility with a mandatory GUI frontend through a webserver is
positively the most bizarre thing I have ever heard of.No, AOLserver is just that good at database connectivity.... :-) And it
makes a great development environment for various db utilities. Although
the pgdiff people might should mention the need on their summary page....I've heard of more bizarre things, though.....
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
Import Notes
Resolved by subject fallback
On Tuesday 07 January 2003 18:36, Steve Crawford wrote:
I'm busy trying to set up AOLserver to access PostgreSQL. Can you offer any
advice on what driver to use (docs aren't entirely clear on the virtues of
the internal PostgreSQL driver vs. the ARSdigita driver and it looks like
the ARSdigita is being merged into the AOLserver code but that's in a beta
state - a bit of a headache for an AOLserver newbie).
The officially sanctioned latest driver version in 3.5, found on the
SourceForge AOLserver file download page.
OpenACS is built on top of AOLserver, it's true; they are still separate
projects, even though the driver has hooks in it for OpenACS use. The
OpenACS sample tcl config shows how to load the nspostgres driver (even
though it may call it 'postgres' instead).
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11