Forum OpenACS Q&A: Anyone using dbVisualizer?

Collapse
Posted by Patrick Giagnocavo on
I came across this Java-based program and was wondering if
anyone has used it:

http://www.ideit.com/products/dbvis/index.html

Since it connects to both PG and Oracle via JDBC, I was thinking
it could be useful in porting/analyzing SQL queries. It seems to
have a nice way of visualizing indexes, anyways.

Collapse
Posted by Don Baccus on
Haven't used it, no.  You might also want to check out the PHP web-based tool that's downloadable from www.greatbridge.org (yes, .org, not .com - it's the site they put up to support open source PG-based projects).  This is a port of a popular PHP/MySQL tool that allows you to wander through your database via the web.  Since PHP isn't threadsafe, it might be nice to recast this in adp/tcl form.

Both tools might be useful, i.e. the Java-based tool (which I assume opens windows in X, rather than generate web pages) for local work, the PHP tool for remote management over net connections too slow to make X a reasonable option.

Collapse
Posted by Jonathan Ellis on
Just wanted to point out that php4 is threadsafe.
Collapse
Posted by Don Baccus on
Hmmm...that was written Feb 27, 2000.  More recent news has been that
thread safety is still an issue. Roberto Mello may have more
information regarding this.

Clearly they WANT php4 to be threadsafe, I guess the question is
whether or not they've accomplished this and there seem to be some
folks at least who believe that they haven't.