[ Replies set to hackers.]

I have started coding a user/group administration tool that allows you
to add/modify/delete users and groups.  I should have something working
in a week.  I will look similar to my pgmonitor tool.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 29 Mar 2001 22:12:45 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
User administration tool
Bruce Momjian writes:

> I have started coding a user/group administration tool that allows you
> to add/modify/delete users and groups.  I should have something working
> in a week.  I will look similar to my pgmonitor tool.

Pgaccess already does part of this.  If you're going to write it in Tcl/Tk
anyway, I think you might as well integrate it there.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Fri, 30 Mar 2001 17:24:30 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: [ADMIN] User administration tool
> Bruce Momjian writes:
> 
> > I have started coding a user/group administration tool that allows you
> > to add/modify/delete users and groups.  I should have something working
> > in a week.  I will look similar to my pgmonitor tool.
> 
> Pgaccess already does part of this.  If you're going to write it in Tcl/Tk
> anyway, I think you might as well integrate it there.

Wow, I see.  I never suspected it did that too.  :-)  Seems I don't need
to write anything, except perhaps add group capabilities to pgaccess.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 30 Mar 2001 10:48:54 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: User administration tool
On Fri, Mar 30, 2001 at 10:48:54AM -0500, Bruce Momjian wrote:
> > Bruce Momjian writes:
> > 
> > > I have started coding a user/group administration tool that allows you
> > > to add/modify/delete users and groups.  I should have something working
> > > in a week.  I will look similar to my pgmonitor tool.
> > 
> > Pgaccess already does part of this.  If you're going to write it in Tcl/Tk
> > anyway, I think you might as well integrate it there.
> 
> Wow, I see.  I never suspected it did that too.  :-)  Seems I don't need
> to write anything, except perhaps add group capabilities to pgaccess.

Isn't phpPgAdmin yet another tool of this type? I haven't tried it myself,
(no need, myself being the only user...) but the web page
(http://www.greatbridge.org/project/phppgadmin/projdisplay.php) says:

    Features include: 

    * create and drop databases 
    * create, copy, drop and alter
      tables/views/sequences/functions/indicies/triggers 
    * edit and add fields (to the extent Postgres allows) 
    * execute any SQL-statement, even batch-queries 
    * manage primary and unique keys 
    * create and read dumps of tables 
    * administer one single database 
    * administer multiple servers 
    * administer postgres users and groups 

Greetinx, Jan
-- 
 +- Jan T. Kim -------------------------------------------------------+
 |  *NEW* -->  email: kim@inb.mu-luebeck.de                           |
 |  *NEW* -->  WWW:   http://www.inb.mu-luebeck.de/staff/kim.html     |
 *-----=<  hierarchical systems are for files, not for humans  >=-----*

Fri, 30 Mar 2001 21:20:49 +0200
"Jan T. Kim" <kim@inb.mu-luebeck.de>
Re: [ADMIN] User administration tool
> > Wow, I see.  I never suspected it did that too.  :-)  Seems I don't need
> > to write anything, except perhaps add group capabilities to pgaccess.
> 
> Isn't phpPgAdmin yet another tool of this type? I haven't tried it myself,
> (no need, myself being the only user...) but the web page
> (http://www.greatbridge.org/project/phppgadmin/projdisplay.php) says:

Yes, it is.  Some people prefer a non-web interaface.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 30 Mar 2001 14:23:31 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [ADMIN] User administration tool

<moved to -interfaces, where it belongs ... >

On Fri, 30 Mar 2001, Bruce Momjian wrote:

> > > Wow, I see.  I never suspected it did that too.  :-)  Seems I don't need
> > > to write anything, except perhaps add group capabilities to pgaccess.
> >
> > Isn't phpPgAdmin yet another tool of this type? I haven't tried it myself,
> > (no need, myself being the only user...) but the web page
> > (http://www.greatbridge.org/project/phppgadmin/projdisplay.php) says:
>
> Yes, it is.  Some people prefer a non-web interaface.

I could understand this sentiment if you were doing something from the
command line, but if you are doing an interface in tcl/tk, I think a web
interface fairs better ...

tcl/tk, you have to be on the same machine or risk "network problems"
losing your link ... web, its a stateless connection, so each time you do
something, it re-establishes the connection and performs the operation ...

IMHO, a web interface will always be appropriate in a network environment,
unless you have the luxury of sitting on the same machine you are running
the X app (tcl/tk) on ... *shrug*




Fri, 30 Mar 2001 15:44:23 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] Re: [ADMIN] User administration tool
The Hermit Hacker writes:

> > Yes, it is.  Some people prefer a non-web interaface.
>
> I could understand this sentiment if you were doing something from the
> command line, but if you are doing an interface in tcl/tk, I think a web
> interface fairs better ...
>
> tcl/tk, you have to be on the same machine or risk "network problems"
> losing your link ...

A Tcl/Tk applications doesn't risk any more network problems than any
other interface to the database, unless that interface is run on the same
machine as the database, which is by no means a given.

If you are under a constant risk of "network problems" then you better fix
your network.  A web interface won't magically bridge network problems.

> web, its a stateless connection, so each time you do something, it
> re-establishes the connection and performs the operation ...

It makes the whole thing slower and won't let you preserve state.  This
seems to be a disadvantage to me.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Fri, 30 Mar 2001 23:45:39 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] Re: [ADMIN] User administration tool
On Fri, 30 Mar 2001, Peter Eisentraut wrote:

> The Hermit Hacker writes:
>
> > > Yes, it is.  Some people prefer a non-web interaface.
> >
> > I could understand this sentiment if you were doing something from the
> > command line, but if you are doing an interface in tcl/tk, I think a web
> > interface fairs better ...
> >
> > tcl/tk, you have to be on the same machine or risk "network problems"
> > losing your link ...
>
> A Tcl/Tk applications doesn't risk any more network problems than any
> other interface to the database, unless that interface is run on the same
> machine as the database, which is by no means a given.
>
> If you are under a constant risk of "network problems" then you better fix
> your network.  A web interface won't magically bridge network problems.

my "network problem" happens to be a database server half way across the
country from me ... running a tcl/tk interface would be useless, while a
web interface does exactly what I need ...



Fri, 30 Mar 2001 17:48:47 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] Re: [ADMIN] User administration tool