pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedGraphical database maintenence design tool
7+ messages / 7 participants
[nested] [flat]
* Graphical database maintenence design tool
@ 1998-06-03 00:39 Peter Cordone <pcordone@ee.net>
0 siblings, 4 replies; 7+ messages in thread
From: Peter Cordone @ 1998-06-03 00:39 UTC (permalink / raw)
To: pgsql-general@postgresql.org
I am new to Postgres and somewhat new to Linux and Unix. I am trying to
find a graphical tool that I can use to do my database table design, in
XWindows or one that I can run in Microsoft Windows NT over my network.
Can anyone suggest anything?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [GENERAL] Graphical database maintenence design tool
@ 1998-06-03 01:21 The Hermit Hacker <scrappy@hub.org>
parent: Peter Cordone <pcordone@ee.net>
3 siblings, 0 replies; 7+ messages in thread
From: The Hermit Hacker @ 1998-06-03 01:21 UTC (permalink / raw)
To: Peter Cordone <pcordone@ee.net>; +Cc: pgsql-general@postgreSQL.org
On Tue, 2 Jun 1998, Peter Cordone wrote:
> I am new to Postgres and somewhat new to Linux and Unix. I am trying to
> find a graphical tool that I can use to do my database table design, in
> XWindows or one that I can run in Microsoft Windows NT over my network.
>
> Can anyone suggest anything?
There are several in existence.
pgaccess is raved about, and comes wiht the distribution in the
src/bin directory.
If you looked at http://www.postgresql.org/cd-dist.shtml, there
are links to various third-party interfaces that are included on the CD,
with two more being added shortly...
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [GENERAL] Graphical database maintenence design tool
@ 1998-06-03 02:34 Brett W. McCoy <bmccoy@lan2wan.com>
parent: Peter Cordone <pcordone@ee.net>
3 siblings, 0 replies; 7+ messages in thread
From: Brett W. McCoy @ 1998-06-03 02:34 UTC (permalink / raw)
To: Peter Cordone <pcordone@ee.net>; +Cc: pgsql-general@postgreSQL.org
On Tue, 2 Jun 1998, Peter Cordone wrote:
> I am new to Postgres and somewhat new to Linux and Unix. I am trying to
> find a graphical tool that I can use to do my database table design, in
> XWindows or one that I can run in Microsoft Windows NT over my network.
pgaccess is what you may want to look into. It is a Tcl/Tk application,
and is reminiscent of Access, but is a front end to Postgres (you would
use pgaccess instead of psql). Another option is to install the PostODBC
drivers and use Access itself (or something similar) to use under Windows
and connect to the server. A quick and dirty method is to create your
tables with psql, input the data into an Access database, and then import
the data into postgres.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [GENERAL] Graphical database maintenence design tool
@ 1998-06-03 18:10 Peter Mount <pgsqlgen@retep.org.uk>
parent: Peter Cordone <pcordone@ee.net>
3 siblings, 0 replies; 7+ messages in thread
From: Peter Mount @ 1998-06-03 18:10 UTC (permalink / raw)
To: Peter Cordone <pcordone@ee.net>; +Cc: pgsql-general@postgresql.org
On Tue, 2 Jun 1998, Peter Cordone wrote:
> I am new to Postgres and somewhat new to Linux and Unix. I am trying to
> find a graphical tool that I can use to do my database table design, in
> XWindows or one that I can run in Microsoft Windows NT over my network.
>
> Can anyone suggest anything?
There are also quite a few Java JDBC Applications out there that will run
on both Linux and NT without recompiling. Check on www.gamelan.com
I know of two works in progres for Postgresql:
WIDD by Nicolas Prochazka <nprochaz@etu.info.unicaen.fr> is in its early
stages, but it looks pretty good. It can handle the display of large
objects, and sql queries open up browser windows.
Finder by me is a little larger, but it's primarily an Astronomical
application, with some PostgreSQL management functions, and the ability to
display query results in both tabular and graphical forms.
--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [GENERAL] Graphical database maintenence design tool
@ 1998-06-07 08:30 Herouth Maoz <herouth@oumail.openu.ac.il>
parent: Peter Cordone <pcordone@ee.net>
3 siblings, 1 reply; 7+ messages in thread
From: Herouth Maoz @ 1998-06-07 08:30 UTC (permalink / raw)
To: Peter Mount <pgsqlgen@retep.org.uk>; +Cc: pgsql-interfaces
At 21:10 +0300 on 3/6/98, Peter Mount wrote:
> On Tue, 2 Jun 1998, Peter Cordone wrote:
>
> > I am new to Postgres and somewhat new to Linux and Unix. I am trying to
> > find a graphical tool that I can use to do my database table design, in
> > XWindows or one that I can run in Microsoft Windows NT over my network.
> >
> > Can anyone suggest anything?
>
> There are also quite a few Java JDBC Applications out there that will run
> on both Linux and NT without recompiling. Check on www.gamelan.com
Peter, I remember you gave me the same answer a while ago, but frankly,
I've been roaming around gamelan lately (after my attempt with pgAccess
failed), and I didn't see anything which fits the description. I saw a few
tools which, from the descriptions, are nothing more than places to insert
a query and see the results. If you're lucky, you see the results
graphically. I just wonder if there's any took I've skipped, or if I looked
in the wrong place at gamelan. Do you have any actual name of any software
(preferable not commercial) which you know does it?
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [GENERAL] Graphical database maintenence design tool
@ 1998-06-07 13:13 leif@danmos.dk
0 siblings, 0 replies; 7+ messages in thread
From: leif@danmos.dk @ 1998-06-07 13:13 UTC (permalink / raw)
To: pgsql-interfaces
Hi Peter, Peter and Herouth (and everybody else),
On: Sun, 7 Jun 1998 11:30:23 +0300 you wrote
> At 21:10 +0300 on 3/6/98, Peter Mount wrote:
>
>
> > On Tue, 2 Jun 1998, Peter Cordone wrote:
> >
> > > I am new to Postgres and somewhat new to Linux and Unix. I am trying to
> > > find a graphical tool that I can use to do my database table design, in
> > > XWindows or one that I can run in Microsoft Windows NT over my network.
> > >
> > > Can anyone suggest anything?
> >
> > There are also quite a few Java JDBC Applications out there that will run
> > on both Linux and NT without recompiling. Check on www.gamelan.com
>
> Peter, I remember you gave me the same answer a while ago, but frankly,
> I've been roaming around gamelan lately (after my attempt with pgAccess
> failed), and I didn't see anything which fits the description. I saw a few
> tools which, from the descriptions, are nothing more than places to insert
> a query and see the results. If you're lucky, you see the results
> graphically. I just wonder if there's any took I've skipped, or if I looked
> in the wrong place at gamelan. Do you have any actual name of any software
> (preferable not commercial) which you know does it?
>
I am very new to this list, so didn't notice the above correspondence
before. I have been using a multi platform GUI development toolkit called
wxWindows for a couple of years now. I have been working a little with ODBC
and wxWindows for some time too.
wxWindows is freeware :-). It is good :-). It is extensible (I wonder if
this is the right word, I mean it has an awful lot of features) :-). The
source code is free :-) (Not even GNU). It has a lot of examples and
utilities :-). You get extremely good support :-). The only (little) drawback
is that the Gui builder tools are not complete, but the Dialoged (-itor) is
quite good. The main URL is
http://web.ukonline.co.uk/julian.smart/index.html
It runs on UNIX (most flavours, Motif, Xt, XView is a little old), Windows 95,
Windows NT, and Windows 3.11.
I am just about to release a very complex addition to wxWindows (DBGrid),
which is an ODBC based database table, with a lot of features (maybe too many
features.) I recently started to have a look at PostgreSQL, which I now have
up and running with interface both on UNIX (Linux) and Windoes 95 using this
DBGrid. I just have one minor obstacle left, which some of you might be able
to help me with:
On Win95 everything is fine, but on Linux I am using Sergey's pgodbc
driver for connecting to PostgreSQL on my server (another Linux box) running
postmaster -i ... The problem is that when I call any of the ODBC/SQL...
functions it gets duplicated. It seems that the duplication is somewhere
between iodbc (the ODBC manager) and pgodbc (Sergey's ODBC driver). psql
works fine on both systems.
This little problem is the only thing left for me to resolv before I
release the DBGrid class.
Greetings,
___________________________________________________________________________
/
_/ _/_/ / Leif Jensen (leif@danmos.dk)
_/ _/ _/ /
_/ _/_/ _/_/_/ /
_/ _/ _/ _/ _/ / Linux 2.0.33, gcc 2.7.2, wxWin 1.66F
_/ _/ _/_/ _/ _/ /
_/ _/ _/ _/ _/ /
_/_/_/_/ _/_/ _/_/ _/ / (and Windows 95 :-(
___________________________________________________________________________
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] Re: [GENERAL] Graphical database maintenence design tool
@ 1998-06-07 17:16 Peter T Mount <pgint@maidast.demon.co.uk>
parent: Herouth Maoz <herouth@oumail.openu.ac.il>
0 siblings, 0 replies; 7+ messages in thread
From: Peter T Mount @ 1998-06-07 17:16 UTC (permalink / raw)
To: Herouth Maoz <herouth@oumail.openu.ac.il>; +Cc: Peter Mount <pgsqlgen@retep.org.uk>; pgsql-interfaces
On Sun, 7 Jun 1998, Herouth Maoz wrote:
> At 21:10 +0300 on 3/6/98, Peter Mount wrote:
>
>
> > On Tue, 2 Jun 1998, Peter Cordone wrote:
> >
> > > I am new to Postgres and somewhat new to Linux and Unix. I am trying to
> > > find a graphical tool that I can use to do my database table design, in
> > > XWindows or one that I can run in Microsoft Windows NT over my network.
> > >
> > > Can anyone suggest anything?
> >
> > There are also quite a few Java JDBC Applications out there that will run
> > on both Linux and NT without recompiling. Check on www.gamelan.com
>
> Peter, I remember you gave me the same answer a while ago, but frankly,
> I've been roaming around gamelan lately (after my attempt with pgAccess
> failed), and I didn't see anything which fits the description. I saw a few
> tools which, from the descriptions, are nothing more than places to insert
> a query and see the results. If you're lucky, you see the results
> graphically. I just wonder if there's any took I've skipped, or if I looked
> in the wrong place at gamelan.
I think most of them are just that - enter a query and get the results
out.
> Do you have any actual name of any software (preferable not commercial)
> which you know does it?
I can't remember what it was called, but I did see one that did allow some
administration a while back. I'll try to dig it up.
--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~1998-06-07 17:16 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-03 00:39 Graphical database maintenence design tool Peter Cordone <pcordone@ee.net>
1998-06-03 01:21 ` The Hermit Hacker <scrappy@hub.org>
1998-06-03 02:34 ` Brett W. McCoy <bmccoy@lan2wan.com>
1998-06-03 18:10 ` Peter Mount <pgsqlgen@retep.org.uk>
1998-06-07 08:30 ` Herouth Maoz <herouth@oumail.openu.ac.il>
1998-06-07 17:16 ` Peter T Mount <pgint@maidast.demon.co.uk>
1998-06-07 13:13 Re: [GENERAL] Graphical database maintenence design tool leif@danmos.dk
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox