About Tools at the DB design phase.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

About Tools at the DB design phase.

Ying Lu
Greetings,

I am at the design phase of the DB design. That is, I'd like to design
tables and relationships between them, but not the real implement of
tables. Could somebody suggest some good and free tools to help/ease
design the structures please?

Thanks a lot!
Emi



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

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: About Tools at the DB design phase.

Roman Neuhauser
# [hidden email] / 2005-07-27 10:05:43 -0400:
> Greetings,
>
> I am at the design phase of the DB design. That is, I'd like to design
> tables and relationships between them, but not the real implement of
> tables. Could somebody suggest some good and free tools to help/ease
> design the structures please?

    They're not exactly free, but a pen and a hardback notebook (A4)
    have proven to be the best tools over the time.

    YMMV.

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

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

               http://archives.postgresql.org
Reply | Threaded
Open this post in threaded view
|

Re: About Tools at the DB design phase.

snorkel
In reply to this post by Ying Lu
Zeos Database Designer is OK.

http://www.zeoslib.net

Tony Caduto
http://www.amsoftwaredesign.com/lightning_admin.php
Home of PG Lightning Admin (PGLA) for Postgresql 8.x




Ying Lu wrote:

> Greetings,
>
> I am at the design phase of the DB design. That is, I'd like to design
> tables and relationships between them, but not the real implement of
> tables. Could somebody suggest some good and free tools to help/ease
> design the structures please?
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: About Tools at the DB design phase.

Ben Chobot
In reply to this post by Roman Neuhauser
Heh, I have to concur with this comment. Though I always found the US
letter format to be more standards compliant, myself.

On Wed, 27 Jul 2005, Roman Neuhauser wrote:

> # [hidden email] / 2005-07-27 10:05:43 -0400:
> > Greetings,
> >
> > I am at the design phase of the DB design. That is, I'd like to design
> > tables and relationships between them, but not the real implement of
> > tables. Could somebody suggest some good and free tools to help/ease
> > design the structures please?
>
>     They're not exactly free, but a pen and a hardback notebook (A4)
>     have proven to be the best tools over the time.
>
>     YMMV.



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
Reply | Threaded
Open this post in threaded view
|

Re: About Tools at the DB design phase.

Roman Neuhauser
# [hidden email] / 2005-07-27 10:13:10 -0700:

> On Wed, 27 Jul 2005, Roman Neuhauser wrote:
> > # [hidden email] / 2005-07-27 10:05:43 -0400:
> > > I am at the design phase of the DB design. That is, I'd like to design
> > > tables and relationships between them, but not the real implement of
> > > tables. Could somebody suggest some good and free tools to help/ease
> > > design the structures please?
> >
> >     They're not exactly free, but a pen and a hardback notebook (A4)
> >     have proven to be the best tools over the time.
> >
> >     YMMV.
>
> Heh, I have to concur with this comment. Though I always found the US
> letter format to be more standards compliant, myself.

    This is the Central Europe, sir. You either play by the continental
    standards or we send you back home. ;)

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match