Thread: Database Design tool

Database Design tool

From
Viacheslav N Tararin
Date:
Hi.

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

thanks.


Re: Database Design tool

From
Bhuvan A
Date:
> Can anybody take me reference on Database design tool with PostgreSQL 
> support.
> 

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

regards,
bhuvaneswaran



Re: Database Design tool

From
Tomasz Myrta
Date:
Uz.ytkownik Viacheslav N Tararin napisa?:
> Hi.
>
> Can anybody take me reference on Database design tool with PostgreSQL
> support.

pgadmin.postgresql.org

Tomasz Myrta


Re: Database Design tool

From
Johannes Lochmann
Date:
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


Re: Database Design tool

From
Dan Hrabarchuk
Date:
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)



Re: Database Design tool

From
Kevin Old
Date:
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>


Re: Database Design tool

From
Wei Weng
Date:
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.




Re: Database Design tool

From
Josh Berkus
Date:
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 BerkusAglio Database SolutionsSan Francisco



Re: Database Design tool

From
Wei Weng
Date:
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.




Re: Database Design tool

From
Josh Berkus
Date:
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 BerkusAglio Database SolutionsSan Francisco



Re: Database Design tool

From
Reinoud van Leeuwen
Date:
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


Re: [GENERAL] Database Design tool

From
Diogo Biazus
Date:
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