Обсуждение: Re: Need for java based web admin tool

On 22.09.2005 20:41, Jobu wrote:
> Is there a java based web admin or is it just a dream and there is no java analog for phpPgAdmin?

There is none to my knowledge. Java client side frontends such as Aqua
Data Studio (http://www.aquafold.com/) exist..

> ..which runs in Java Application Server (Tomcat).

So if you have Apache running anyway, why not load up mod_php, drop
phpPgAdmin in a dir and be happy? Does it necessarily have to be
webbased? IMHO it's a pain to administrate a DBMS over a webfront.

If it just needs to work over HTTP, there are frontends that can tunnel
over a HTTP connection. EMS Postgres Manager is one of them and the lite
versions are free.

http://www.sqlmanager.net


--
Regards,
Hannes Dorbath

> I would like to install to client machine only Tomcat (You can't use php in Tomcat).

I might be wrong, but isn't it a common setup to have an apache running
in front of tomcat and having apache passing all JSP requests to tomcat ?

> And I would like to leave postgres ports closed, so HTTP tunneling is not a good solution...

That's what EMS PGM's HTTP tunneling is all about. You put a PHP proxy
script on your server, it uses Unix sockets to connect to the local PG
server and the EMS frontend calls that script over HTTP -- and it works
very well.

> But EMS Postgres Manager seams to be a nice tool, so thanks anyway.

IMHO the best win32 frontend out there.


--
Regards,
Hannes Dorbath

> If it just needs to work over HTTP, there are frontends that can tunnel
> over a HTTP connection. EMS Postgres Manager is one of them and the lite
> versions are free.
>
> http://www.sqlmanager.net


Hannes,

How to edit the table data with free version ( addd, delete, filter rows)?

pgAdmin allows to edit data in table form but I havent found any such
possibility in SQL Manager.

Andrus.