Thread: GUI Tools For PostgreSQL

GUI Tools For PostgreSQL

From
Josh Berkus
Date:
Ms. Matthews,

PostgreSQL, like other "real" database systems (such as Oracle, SQL Server,
and DB2) does not include a GUI interface as a part of the database.
Instead, there are several different GUIs which you can use, depending on
your operating system, needs, and programming language:

http://techdocs.postgresql.org/guides/GUITools

Also, you will want to join the pgsql-novice mailing list to ask additional
questions you might have regarding getting up & running on PostgreSQL:
send e-mail to: majordomo@postgresql.org
subject: <blank>
message:  subscribe pgsql-novice

--
Josh Berkus
Aglio Database Solutions
San Francisco


Re: GUI Tools For PostgreSQL

From
Ryan Mahoney
Date:
Not sure about DB2, but SQL server comes with a GUI and so does Oracle.
I don't think most Oracle and SQL server admins use these tools, but
they are usually installed with the DB installer program.  BY GUI I am
assuming you mean a program that runs in a wondowed environment that
allows you to view and manipulate your data graphically without entering
SQL commands by hand.

-r

On Mon, 2003-05-05 at 11:58, Josh Berkus wrote:
> Ms. Matthews,
>
> PostgreSQL, like other "real" database systems (such as Oracle, SQL Server,
> and DB2) does not include a GUI interface as a part of the database.
> Instead, there are several different GUIs which you can use, depending on
> your operating system, needs, and programming language:
>
> http://techdocs.postgresql.org/guides/GUITools
>
> Also, you will want to join the pgsql-novice mailing list to ask additional
> questions you might have regarding getting up & running on PostgreSQL:
> send e-mail to: majordomo@postgresql.org
> subject: <blank>
> message:  subscribe pgsql-novice
--
Ryan Mahoney <ryan@paymentalliance.net>


Re: GUI Tools For PostgreSQL

From
Josh Berkus
Date:
Ryan,

> Not sure about DB2, but SQL server comes with a GUI and so does Oracle.
> I don't think most Oracle and SQL server admins use these tools, but
> they are usually installed with the DB installer program.  BY GUI I am
> assuming you mean a program that runs in a wondowed environment that
> allows you to view and manipulate your data graphically without entering
> SQL commands by hand.

Hmmmm .... good point; I was thinking MS Access/Filemaker-style GUI, which is
pretty much what I'm sure she meant, but it doesn't pay to assume.  Will
follow up with her.

> > PostgreSQL, like other "real" database systems (such as Oracle, SQL
> > Server, and DB2) does not include a GUI interface as a part of the
> > database. Instead, there are several different GUIs which you can use,
> > depending on your operating system, needs, and programming language:
> >
> > http://techdocs.postgresql.org/guides/GUITools
> >
> > Also, you will want to join the pgsql-novice mailing list to ask
> > additional questions you might have regarding getting up & running on
> > PostgreSQL: send e-mail to: majordomo@postgresql.org
> > subject: <blank>
> > message:  subscribe pgsql-novice

--
Josh Berkus
Aglio Database Solutions
San Francisco


Re: GUI Tools For PostgreSQL

From
Gavin Sherry
Date:
On 5 May 2003, Ryan Mahoney wrote:

> Not sure about DB2, but SQL server comes with a GUI and so does Oracle.

DB2 did when I was using it two years ago.

Gavin


Re: GUI Tools For PostgreSQL

From
Diogo de Oliveira Biazus
Date:
Gavin Sherry wrote:

>On 5 May 2003, Ryan Mahoney wrote:
>
>
>
>>Not sure about DB2, but SQL server comes with a GUI and so does Oracle.
>>
>>
>
>DB2 did when I was using it two years ago.
>
By the way, I think it would be nice, for newbies, to have a PostgreSQL
package with a default GUI tool.
It's good for people who are starting to use it, it's more confortable,
in my opinion.
What do you think?

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br


Re: GUI Tools For PostgreSQL

From
Josh Berkus
Date:
Diogo,

> By the way, I think it would be nice, for newbies, to have a PostgreSQL
> package with a default GUI tool.
> It's good for people who are starting to use it, it's more confortable,
> in my opinion.
> What do you think?

I do *not* want to arbitrate between the PGAdmin and PGAccess projects to
decied who's the default.  No way.

Besides, PostgreSQL runs on more platforms than any individual GUI does.
Plus If we include one specific GUI in the .taz.gz, then  we've added to the
download size of the file, which is a burden on the users who didn't want a
GUI at all.

I *do* think it would be a good idea to create a "So You've Just Downloaded
PostgreSQL" page with links to all of the following:
-- Instructions on installing
-- The GUI list.
-- Popular GBorg projects which are PostgreSQL accessories
-- A guide to /contrib
-- A link to the "Annotated PostgreSQL.conf"  (coming soon from me).
-- The mailing lists page



--
Josh Berkus
Aglio Database Solutions
San Francisco


Re: GUI Tools For PostgreSQL

From
Robert Treat
Date:
On Tue, 2003-05-06 at 11:42, Josh Berkus wrote:
> Diogo,
>
> > By the way, I think it would be nice, for newbies, to have a PostgreSQL
> > package with a default GUI tool.
> > It's good for people who are starting to use it, it's more confortable,
> > in my opinion.
> > What do you think?
>
> I do *not* want to arbitrate between the PGAdmin and PGAccess projects to
> decied who's the default.  No way.
>

That's easy, use phpPgAdmin :-)


> Besides, PostgreSQL runs on more platforms than any individual GUI does.
> Plus If we include one specific GUI in the .taz.gz, then  we've added to the
> download size of the file, which is a burden on the users who didn't want a
> GUI at all.
>

There are a few projects that install mysql, apache, php, and
phpMyAdmin, all in one shebang, for windows. One of these days I hope we
can do something like that...

Robert Treat


Re: GUI Tools For PostgreSQL

From
elein
Date:
With regards to GUI tool kits, there are two kinds you are talking
about.  One kind is an administration gui with or without design
capabilities like pgaccess.

The other is a 3GL or 4GL or script language GUI like forte (used to be) or TCL
to develop forms for a database application. *Our* strength is that we work
well with a lot of client development tools.  However, I don't know of any
that are integrated with the system catalog.  I'd sure like a gui tool
that can throw up a form based on a view or table and just do the right
thing.  There may be something close like gnomedb, but I've never been
able to get one to work (that I didn't write myself :-).

elein

On Tuesday 06 May 2003 10:45, Robert Treat wrote:
> On Tue, 2003-05-06 at 11:42, Josh Berkus wrote:
> > Diogo,
> >
> > > By the way, I think it would be nice, for newbies, to have a PostgreSQL
> > > package with a default GUI tool.
> > > It's good for people who are starting to use it, it's more confortable,
> > > in my opinion.
> > > What do you think?
> >
> > I do *not* want to arbitrate between the PGAdmin and PGAccess projects to
> > decied who's the default.  No way.
> >
>
> That's easy, use phpPgAdmin :-)
>
>
> > Besides, PostgreSQL runs on more platforms than any individual GUI does.
> > Plus If we include one specific GUI in the .taz.gz, then  we've added to the
> > download size of the file, which is a burden on the users who didn't want a
> > GUI at all.
> >
>
> There are a few projects that install mysql, apache, php, and
> phpMyAdmin, all in one shebang, for windows. One of these days I hope we
> can do something like that...
>
> Robert Treat
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

--
=============================================================
elein@varlena.com     Database Consulting     www.varlena.com
PostgreSQL General Bits    http:/www.varlena.com/GeneralBits/
   "Left foot, right foot, left foot, breathe.
   Right foot, left foot, right foot, breathe." --Father Tom


Re: GUI Tools For PostgreSQL

From
Diogo de Oliveira Biazus
Date:
Josh Berkus wrote:

>I do *not* want to arbitrate between the PGAdmin and PGAccess projects to
>decied who's the default.  No way.
>
>Besides, PostgreSQL runs on more platforms than any individual GUI does.
>Plus If we include one specific GUI in the .taz.gz, then  we've added to the
>download size of the file, which is a burden on the users who didn't want a
>GUI at all.
>
>I *do* think it would be a good idea to create a "So You've Just Downloaded
>PostgreSQL" page with links to all of the following:
>-- Instructions on installing
>-- The GUI list.
>-- Popular GBorg projects which are PostgreSQL accessories
>-- A guide to /contrib
>-- A link to the "Annotated PostgreSQL.conf"  (coming soon from me).
>-- The mailing lists page
>
I agree with various arguments sent to the list.
Now I think that this idea of a "Start Using PostgreSQL Page" with this
links would be nice (if it doesn't exist already).
The user could be redirected to this page after the download, or just
before.

--
Diogo de Oliveira Biazus
diogo@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br


Re: GUI Tools For PostgreSQL

From
Jean-Michel POURE
Date:
> I do *not* want to arbitrate between the PGAdmin and PGAccess projects to
> decied who's the default.  No way.

Arbitrating between pgAdmin and pgAccess is not at stake here. User have needs
and software producers like the PostgreSQL community tend to answer these
needs.

In the case of PostgreSQL, users needs a web interface (1) and a
multi-platform GUI (2). Other tools like pgsql are already provided.
Therefore, in my opinion, the question at stake is:

"does a bundle including a web interface and a multi-platform GUI will
speed-up the adoption of PostgreSQL?"

I can't answer myself, it's your choice as a community.

Cheers, Jean-Michel


Re: GUI Tools For PostgreSQL

From
Josh Berkus
Date:
Jean-Michel,

> Arbitrating between pgAdmin and pgAccess is not at stake here. User have
> needs and software producers like the PostgreSQL community tend to answer
> these needs.

But picking one ... and only one ... *is* the issue.   Are we going to
effectively endorse PGAccess over PGAdmin and Xpg?  Or vice-versa?   Web
access is, fortunately easy due to the monopoly of PHPpgAdmin, but which
client-side GUI to use would be a very hard decision ... and would piss off a
significant contributor to Postgres no matter how you look at it.

> In the case of PostgreSQL, users needs a web interface (1) and a
> multi-platform GUI (2). Other tools like pgsql are already provided.
> Therefore, in my opinion, the question at stake is:
>
> "does a bundle including a web interface and a multi-platform GUI will
> speed-up the adoption of PostgreSQL?"

Not as much as a windows port will ;-)

I do think that a PHP/Apache/PostgreSQL/PHPpgAdmin bundle is a great idea, and
doesn't step on anyone's toes.   The question is ... who on this list is
going to do it?

--
Josh Berkus
Aglio Database Solutions
San Francisco


Re: GUI Tools For PostgreSQL

From
"Christopher Kings-Lynne"
Date:
> I do think that a PHP/Apache/PostgreSQL/PHPpgAdmin bundle is a great idea,
and
> doesn't step on anyone's toes.   The question is ... who on this list is
> going to do it?

Well the total rewrite of phpPgAdmin for v3 will be in beta soon.  I'm the
admin of the phpPgAdmin project, so if anyone has any feature requests
before beta....

Chris