Database Design tool

Started by Viacheslav N Tararinover 23 years ago14 messagesgeneral
Jump to latest
#1Viacheslav N Tararin
taras@dekasoft.com.ua

Hi.

Can anybody take me reference on Database design tool with PostgreSQL
support.

thanks.

#2A.Bhuvaneswaran
bhuvansql@myrealbox.com
In reply to: Viacheslav N Tararin (#1)
Re: Database Design tool

Can anybody take me reference on Database design tool with PostgreSQL
support.

visit, http://sourceforge.net/projects/phppgadmin/

regards,
bhuvaneswaran

#3Tomasz Myrta
jasiek@klaster.net
In reply to: Viacheslav N Tararin (#1)
Re: [SQL] Database Design tool

Uz.ytkownik Viacheslav N Tararin napisa?:

Hi.

Can anybody take me reference on Database design tool with PostgreSQL
support.

pgadmin.postgresql.org

Tomasz Myrta

#4Diogo Biazus
diogo@ikono.com.br
In reply to: Viacheslav N Tararin (#1)
Re: Database Design tool

Viacheslav N Tararin wrote:

Hi.

Can anybody take me reference on Database design tool with PostgreSQL
support.

thanks.

There's another one very good called Data Architect:

http://www.thekompany.com/products/dataarchitect/

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

#5Johannes Lochmann
johannes.lochmann@chello.at
In reply to: Viacheslav N Tararin (#1)
Re: [SQL] Database Design tool

On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:

Hi,

(which list should this go to? I guess it is OT on both...)

Can anybody take me reference on Database design tool with PostgreSQL
support.

Dia and dia2sql (or something similar...) Google knows more :-)

HTH

Johannes Lochmann

#6Dan Hrabarchuk
dan@findatradenow.com
In reply to: Johannes Lochmann (#5)
Re: [SQL] Database Design tool

gASQL is a gnome-db client that looks like it has a lot of promise. The
only problem is I've never been able to get the application to run
properly. I'm using RedHat 8.0 on my desktop. The last official version
does not install properly. If I grab a CVS copy, I go through dependency
hell. Has anyone ever actually gotten gASQL to work?

Dan

Show quoted text

On Wed, 2002-10-30 at 06:35, Johannes Lochmann wrote:

On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:

Hi,

(which list should this go to? I guess it is OT on both...)

Can anybody take me reference on Database design tool with PostgreSQL
support.

Dia and dia2sql (or something similar...) Google knows more :-)

HTH

Johannes Lochmann

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

#7Kevin Old
kold@carolina.rr.com
In reply to: Dan Hrabarchuk (#6)
Re: [SQL] Database Design tool

Dan,

I use Xpg....a Java Postgresql client and it is awesome.

It's at http://www.kazak.ws/xpg/

Kevin

On Wed, 2002-10-30 at 10:30, Dan Hrabarchuk wrote:

gASQL is a gnome-db client that looks like it has a lot of promise. The
only problem is I've never been able to get the application to run
properly. I'm using RedHat 8.0 on my desktop. The last official version
does not install properly. If I grab a CVS copy, I go through dependency
hell. Has anyone ever actually gotten gASQL to work?

Dan

On Wed, 2002-10-30 at 06:35, Johannes Lochmann wrote:

On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:

Hi,

(which list should this go to? I guess it is OT on both...)

Can anybody take me reference on Database design tool with PostgreSQL
support.

Dia and dia2sql (or something similar...) Google knows more :-)

HTH

Johannes Lochmann

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Kevin Old <kold@carolina.rr.com>

#8Wei Weng
wweng@kencast.com
In reply to: Kevin Old (#7)
Re: Database Design tool

My colleague installed a redhat database 2(which is based on postgresql)
onto his redhat 7.3 machine and it came with a very nice java query
analyzer tool. It is sort of like the query analyzer in MS SQL Server
with the graphical output of the execution plan, quite intuitive.

I wonder if I can find a standalone java query analyzer package. Does
anyone know?

Thanks

On Wed, 2002-10-30 at 15:42, Kevin Old wrote:

Dan,

I use Xpg....a Java Postgresql client and it is awesome.

It's at http://www.kazak.ws/xpg/

Kevin

On Wed, 2002-10-30 at 10:30, Dan Hrabarchuk wrote:

gASQL is a gnome-db client that looks like it has a lot of promise. The
only problem is I've never been able to get the application to run
properly. I'm using RedHat 8.0 on my desktop. The last official version
does not install properly. If I grab a CVS copy, I go through dependency
hell. Has anyone ever actually gotten gASQL to work?

Dan

On Wed, 2002-10-30 at 06:35, Johannes Lochmann wrote:

On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:

Hi,

(which list should this go to? I guess it is OT on both...)

Can anybody take me reference on Database design tool with PostgreSQL
support.

Dia and dia2sql (or something similar...) Google knows more :-)

HTH

Johannes Lochmann

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Kevin Old <kold@carolina.rr.com>

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

--
Wei Weng
Network Software Engineer
KenCast Inc.

#9Josh Berkus
josh@agliodbs.com
In reply to: Wei Weng (#8)
Re: Database Design tool

Wei,

My colleague installed a redhat database 2(which is based on postgresql)
onto his redhat 7.3 machine and it came with a very nice java query
analyzer tool. It is sort of like the query analyzer in MS SQL Server
with the graphical output of the execution plan, quite intuitive.

I wonder if I can find a standalone java query analyzer package. Does
anyone know?

I believe that Red Hat offers the query analyzer as a download. Check their
site.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

#10Wei Weng
wweng@kencast.com
In reply to: Josh Berkus (#9)
Re: Database Design tool

Josh:

Do you have any idea of what the software is called? I could only find
the redhat database ISO for download.

Thanks

On Wed, 2002-10-30 at 18:43, Josh Berkus wrote:

Wei,

My colleague installed a redhat database 2(which is based on postgresql)
onto his redhat 7.3 machine and it came with a very nice java query
analyzer tool. It is sort of like the query analyzer in MS SQL Server
with the graphical output of the execution plan, quite intuitive.

I wonder if I can find a standalone java query analyzer package. Does
anyone know?

I believe that Red Hat offers the query analyzer as a download. Check their
site.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

--
Wei Weng
Network Software Engineer
KenCast Inc.

#11Josh Berkus
josh@agliodbs.com
In reply to: Wei Weng (#10)
Re: Database Design tool

Wei,

Do you have any idea of what the software is called? I could only find
the redhat database ISO for download.

Announced on PGSQL-ANNOUNCE a couple of weeks ago:
(if you're not subscribed to PGSQL-ANNOUNCE, you should be)

=======================================================
The Red Hat Database Graphical Tools, RHDB Administrator and
Visual Explain, are now available via anonymous CVS checkout
from http://sources.redhat.com/rhdb.

The RHDB development team has imported the inaugural version
of the tools into the RHDB Project Community Tree and will
continually update the tree as internal development progresses.

We have also opened development of the tools to the PostgreSQL
community and will be accepting bug reports / patches at
rhdb@sources.redhat.com.

The RHDB tools were tested and verified against PostgreSQL 7.2.x
clusters.
===========================================================

--
-Josh Berkus
Aglio Database Solutions
San Francisco

#12Reinoud van Leeuwen
reinoud.v@n.leeuwen.net
In reply to: Johannes Lochmann (#5)
Re: Database Design tool

On Wed, 30 Oct 2002 14:35:23 +0000 (UTC), johannes.lochmann@chello.at
(Johannes Lochmann) wrote:

Can anybody take me reference on Database design tool with PostgreSQL
support.

You can use PowerDesigner from Sybase. Windows only. A fully
functional trial version (45 days) is downloadable at www.sybase.com.
it has:
- support for al major databases (Postgresql, Sybase, Oracle, MS SQL,
Mysql)
- support to generate triggers automatically
- nice reporting features
- ability to reverse engineer existing databases (through ODBC of from
a file)
- central repository (database) storage, or storage of your model in
an XML file (which I use to auto generate perl classes from my saved
model)
- UML modeling
- lots of other buzzword-compliant features ";-)

It is an expensive tool, but if you do serious design work, you'll
need a tool like this

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen reinoud.v@n.leeuwen.net
http://www.xs4all.nl/~reinoud

#13Patrick Bakker
patrick@vanbelle.com
In reply to: Reinoud van Leeuwen (#12)
Re: [SQL] Database Design tool

I had gASQL working once but that was awhile ago. gASQL has now been renamed
as Mergeant and is being developed in conjunction with the gnome-db
libraries as far as I know. I don't think there has been a stable release of
it yet, although it is under active development.

Patrick

Show quoted text

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Dan Hrabarchuk
Sent: Wednesday, October 30, 2002 7:31 AM
To: Johannes Lochmann
Cc: pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Subject: Re: [GENERAL] [SQL] Database Design tool

gASQL is a gnome-db client that looks like it has a lot of
promise. The
only problem is I've never been able to get the application to run
properly. I'm using RedHat 8.0 on my desktop. The last
official version
does not install properly. If I grab a CVS copy, I go through
dependency
hell. Has anyone ever actually gotten gASQL to work?

Dan

On Wed, 2002-10-30 at 06:35, Johannes Lochmann wrote:

On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:

Hi,

(which list should this go to? I guess it is OT on both...)

Can anybody take me reference on Database design tool

with PostgreSQL

support.

Dia and dia2sql (or something similar...) Google knows more :-)

HTH

Johannes Lochmann

---------------------------(end of

broadcast)---------------------------

TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to

majordomo@postgresql.org)

---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#14Larry Rosenman
ler@lerctr.org
In reply to: Patrick Bakker (#13)
Re: [SQL] Database Design tool

On Mon, 2002-11-04 at 15:00, Patrick Bakker wrote:

I had gASQL working once but that was awhile ago. gASQL has now been renamed
as Mergeant and is being developed in conjunction with the gnome-db
libraries as far as I know. I don't think there has been a stable release of
it yet, although it is under active development.

I've seen it in FreeBSD ports collection, if that matters to anyone.

It seems to work.

LER

Patrick

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Dan Hrabarchuk
Sent: Wednesday, October 30, 2002 7:31 AM
To: Johannes Lochmann
Cc: pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Subject: Re: [GENERAL] [SQL] Database Design tool

gASQL is a gnome-db client that looks like it has a lot of
promise. The
only problem is I've never been able to get the application to run
properly. I'm using RedHat 8.0 on my desktop. The last
official version
does not install properly. If I grab a CVS copy, I go through
dependency
hell. Has anyone ever actually gotten gASQL to work?

Dan

On Wed, 2002-10-30 at 06:35, Johannes Lochmann wrote:

On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:

Hi,

(which list should this go to? I guess it is OT on both...)

Can anybody take me reference on Database design tool

with PostgreSQL

support.

Dia and dia2sql (or something similar...) Google knows more :-)

HTH

Johannes Lochmann

---------------------------(end of

broadcast)---------------------------

TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to

majordomo@postgresql.org)

---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749