Re: Web-based PSQL?

I've now developed a basic web-based interface to psql (CGI in PERL). It is
quite basic, and at the moment does not report errors from psql properly,
but it could be quite handy in some circumstances. I've no doubt there are
better ways of doing a number of things in it, too!

Of course, allowing this sort of access is potentially very dangerous. It
does offer IP-based security, as well as a username/password combination for
your database, but if you have trust relationships set up for your
webserver, be careful! I take no responsibility for any security problems
this may allow, or indeed any other problems with the script at all!

Comments are welcome, but I have run out of time for this kind of thing for
the moment, so anything other than minor changes people want me to implement
may take a while. You are free to mangle the script yourselves as much as
you like, as long as I'm credited in the script itself.

You can find it at http://users.ox.ac.uk/~cerberus/psql.pl

Yours,
Moray

----------------------------------------------------------------
Moray.McConnachie@computing-services.oxford.ac.uk
----- Original Message -----
From: "Philip Poles" <philip@surfen.com>
To: "Moray McConnachie" <moray.mcconnachie@computing-services.oxford.ac.uk>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, March 29, 2000 5:20 PM
Subject: Re: [GENERAL] Web-based PSQL?


> That's a nice looking interface...
>
> I was wondering if anyone has managed to get it to work with the 7.0betas?
>
> I find that I can connect OK to a 6.5.3 db...in read-only mode, at any
rate.
> When I try to connect to a 7.0b3 db, I get back the message: The selected
> database is not a PostgreSQL v6.5.x system!
> I assume (dangerous word, I know) that this has to do with the psqlODBC
> driver...has anyone else run into this problem ? does anyone know a work
> around...or even if there is a compiled version of the driver that works
with
> v7.x?
>
> Thanx,
>
>     -philip
>
> ----- Original Message -----
> From: Moray McConnachie
<moray.mcconnachie@computing-services.oxford.ac.uk>
> To: Stan Jacobs <jacobs@jtek.com>; Egon Schmid <eschmid@s.netic.de>
> Cc: <pgsql-general@postgresql.org>
> Sent: Wednesday, March 29, 2000 5:55 AM
> Subject: Re: [GENERAL] Web-based PSQL?
>
>
> Whoops, gave wrong URL: pgadmin should be
>
> http://www.vale-it.demon.co.uk/freeware/pgadmin/
>
>
> ----------------------------------------------------------------
> Moray.McConnachie@computing-services.oxford.ac.uk
> ----- Original Message -----
> From: "Stan Jacobs" <jacobs@jtek.com>
> To: "Egon Schmid" <eschmid@s.netic.de>
> Cc: <pgsql-general@postgresql.org>
> Sent: Wednesday, March 29, 2000 9:33 AM
> Subject: Re: [GENERAL] Web-based PSQL?
>
>
>
> I know this has a standard SQL interface, but I was wondering if there was
> an existing web app that let you show schemas, create tables, edit data,
> and all of that from one simple interface.  Does PHP provide this?  Sorry
> for my confusing question. :-)
>
>
>
> On Wed, 29 Mar 2000, Egon Schmid wrote:
>
> > Stan Jacobs wrote:
> >
> > > is there a version of psql that runs via web interface?  It seems like
> it
> > > would be rather trivial to build if it doesn't already exist, right?
> (And
> > > generally, at least to me, "trivial" means someone's already done it.
> > > *smile*)
> >
> > PHP: http://www.php.net/ http://www.php.net/version4
> > http://www.zend.com/
> >
> > -Egon
> >
> > --
> > Six Offene Systeme GmbH. Stuttgart - Berlin - New York.
> > Fon  +49 711 9 90 91 64 · Fax  +49 711 9 90 91 99 · http://www.six.de/
> >
>
>
>
>
>
>