Thread: GUI Tools For PostgreSQL
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
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>
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
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
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
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
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
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
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
> 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
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
> 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