Thread: design tool

design tool

From
Janning Vygen
Date:
are there any good design ttols for postgres?

i found dbdesigner - cant even save projects
dezign - looks good, but only windows

do you know of any other?

janning


Re: design tool

From
John Fabiani
Date:
Janning Vygen wrote:

> are there any good design ttols for postgres?
> 
> i found dbdesigner - cant even save projects
> dezign - looks good, but only windows
> 
> do you know of any other?
> 
> janning
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
I'm not sure what your looking for but I have been using pgAdminII.  But it 
runs onw windows.  It is able to connect to my postgress 7.1.3 on RH 7.2 
without any troubles.  It creates DB and tables, constraints etc.  

But if your talking about something that models.  This is not the tool.
John



Re: design tool

From
John Fabiani
Date:
Janning Vygen wrote:

> are there any good design ttols for postgres?
> 
> i found dbdesigner - cant even save projects
> dezign - looks good, but only windows
> 
> do you know of any other?
> 
> janning
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
I'm not sure what your looking for but I have been using pgAdminII.  But it 
runs onw windows.  It is able to connect to my postgress 7.1.3 on RH 7.2 
without any troubles.  It creates DB and tables, constraints etc.  

But if your talking about something that models.  This is not the tool.
John



Re: design tool

From
Janning Vygen
Date:
Am Dienstag,  6. November 2001 09:43 schrieb John Fabiani:
> Janning Vygen wrote:
> > are there any good design ttols for postgres?
>
> I'm not sure what your looking for but I have been using pgAdminII.


> But if your talking about something that models.  This is not the
> tool. John

i am looking for something that helps me modelling my database like 
Dezign.

janning


-- 
Planwerk 6 /websolutions
Herzogstra�e 86
40215 D�sseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de


Re: design tool

From
Fernando Nasser
Date:
Janning Vygen wrote:
> 
> Am Dienstag,  6. November 2001 09:43 schrieb John Fabiani:
> > Janning Vygen wrote:
> > > are there any good design ttols for postgres?
> >
> > I'm not sure what your looking for but I have been using pgAdminII.
> 
> > But if your talking about something that models.  This is not the
> > tool. John
> 
> i am looking for something that helps me modelling my database like
> Dezign.
> 

ERWin is known to work (through ODBC).  But, again, it is a MS Windows 
program and probably expensive...

-- 
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9


Re: design tool

From
reinoud@xs4all.nl (Reinoud van Leeuwen)
Date:
On Mon, 5 Nov 2001 19:25:01 +0000 (UTC), vygen@gmx.de (Janning Vygen)
wrote:

>are there any good design ttols for postgres?
>
>i found dbdesigner - cant even save projects
>dezign - looks good, but only windows
>
>do you know of any other?

I have used PowerDesigner from Sybase. It supports Postgresql (amongst
50 other database types, from Oracle, Sybase to postgresql, ANSI SQL
or dBase). 
You draw tables, relations and specialisations and with one click on a
button all "create table" and "create trigger" statements are created
for you. It can generate big reports too. If you have an ODBC
connection to your database it can create the database too (or
*change* the current model to the new version)

It has some 'limimations' though
- windoze only (though it might run under VMware)
- it has a, erm, 'professional' price tag

You can download a fully function time-limited evaluation version from
www.sybase.com. (and there seem to be no cracks available..)

I really like it. But database design is just a too small part of my
job to justify the cost...


-- 
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen       reinoud@xs4all.nl
http://www.xs4all.nl/~reinoud
-> when replying to a mailinglist mail, please do  <-
-> *NOT* cc: me as well. If I read the list I will <-
-> receive the reply as well!                      <-
__________________________________________________


Re: design tool

From
Roberto Mello
Date:
On Tue, Nov 06, 2001 at 05:05:54PM +0100, Janning Vygen wrote:
> 
> i am looking for something that helps me modelling my database like 
> Dezign.

pgaccess, included in PostgreSQL, will do some modeling.
I personally think that a text editor is enough 99% of the times.

-Roberto

-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net      http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
 
* * * <- Tribbles  _ _ _ <- after fight with Godzilla