Thread: Database design software

Database design software

From
CSN
Date:
Can anybody recommend any software for creating UML
diagrams and generating the SQL necessary to create
the database? Dia?

__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2

Re: Database design software

From
Medi Montaseri
Date:
Yes, I know of a good one. The pricing is a bit different. The price is
on the hourly used
basis. The cost is $100/ hour. But its an excellent system. It also
makes coffee, attends
meetings and stuff. Its called John Doe the DBA.

Oh...it also has a builtin speech recognition and synthesizer feature...

CSN wrote:

>Can anybody recommend any software for creating UML
>diagrams and generating the SQL necessary to create
>the database? Dia?
>
>__________________________________________________
>Do you Yahoo!?
>U2 on LAUNCH - Exclusive greatest hits videos
>http://launch.yahoo.com/u2
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>




Re: Database design software

From
snpe
Date:
You try Oracle JDeveloper on otn.oracle.com
regards
Haris Peco
On Thursday 07 November 2002 09:05 pm, CSN wrote:
> Can anybody recommend any software for creating UML
> diagrams and generating the SQL necessary to create
> the database? Dia?
>
> __________________________________________________
> Do you Yahoo!?
> U2 on LAUNCH - Exclusive greatest hits videos
> http://launch.yahoo.com/u2
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


Re: Database design software

From
Laurentiu Drob
Date:
CSN wrote:
> Can anybody recommend any software for creating UML
> diagrams and generating the SQL necessary to create
> the database? Dia?
>

I use Dia 0.90 and tedia2sql Perl script (http://tedia2sql.tigris.org)
to translate diagrams in sql scripts. It does a lot of things and if
you can Perl, lucky you! A nice project is uml2sql from
http://sourceforge.net/projects/uml2sql but unfortunately it's stopped.

         Regards,
            lwd.


command

From
Florian Litot
Date:
What is the command to launch a trace
i try postmaster -i -D .... -d 10 >logfile
but the file is create but nothing are in why?
thanks


Re: command

From
"Shridhar Daithankar"
Date:
On 8 Nov 2002 at 9:42, Florian Litot wrote:

> What is the command to launch a trace
> i try postmaster -i -D .... -d 10 >logfile
> but the file is create but nothing are in why?

Try postmaster -i -D .... -d 10 >logfile 2>&1

HTH


Bye
 Shridhar

--
MIT:    The Georgia Tech of the North


Re: command

From
Florian Litot
Date:
yes it's good but can i have the date with each line?

At 10:14 08/11/02, Shridhar Daithankar wrote:
>On 8 Nov 2002 at 9:42, Florian Litot wrote:
>
> > What is the command to launch a trace
> > i try postmaster -i -D .... -d 10 >logfile
> > but the file is create but nothing are in why?
>
>Try postmaster -i -D .... -d 10 >logfile 2>&1
>
>HTH
>
>
>Bye
>  Shridhar
>
>--
>MIT:    The Georgia Tech of the North
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


Re: command

From
"Shridhar Daithankar"
Date:
On 8 Nov 2002 at 11:03, Florian Litot wrote:

> yes it's good but can i have the date with each line?

Err.. I don't think so. Sounds like a good addition to me.

Any ideas?

Bye
 Shridhar

--
Absentee, n.:    A person with an income who has had the forethought to remove
himself from the sphere of exaction.        -- Ambrose Bierce, "The Devil's
Dictionary"


Re: command

From
Lee Kindness
Date:
Use syslog... It's documented on the website and in the
manual... Assuming you are running on Linux then adding/editing:

 syslog = 1 # range 0-2
 syslog_facility = 'LOCAL0'
 syslog_ident = 'postgres'

to $PGDATA/postgresql.conf and:

 local0.*            /var/log/postgresql

to /etc/syslog.conf and then doing:

 /etc/init.d/syslog restart
 /etc/init.d/postgresql restart

should give you the log you're looking for at:

 /var/log/postgresql

I'll leave it to you to translate this to your flavour of UNIX (or
Linux)...

Lee.

Florian Litot writes:
 > yes it's good but can i have the date with each line?
 > At 10:14 08/11/02, Shridhar Daithankar wrote:
 > >On 8 Nov 2002 at 9:42, Florian Litot wrote:
 > > > What is the command to launch a trace
 > > > i try postmaster -i -D .... -d 10 >logfile
 > > > but the file is create but nothing are in why?
 > >Try postmaster -i -D .... -d 10 >logfile 2>&1

Re: command

From
Florian Litot
Date:
nobody know if it is possible to have the date in th e same time eache line ?

At 11:14 08/11/02, Shridhar Daithankar wrote:
>On 8 Nov 2002 at 11:03, Florian Litot wrote:
>
> > yes it's good but can i have the date with each line?
>
>Err.. I don't think so. Sounds like a good addition to me.
>
>Any ideas?
>
>Bye
>  Shridhar
>
>--
>Absentee, n.:   A person with an income who has had the forethought to
>remove
>himself from the sphere of exaction.            -- Ambrose Bierce, "The
>Devil's
>Dictionary"
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


Re: command

From
Shridhar Daithankar
Date:
On Friday 08 November 2002 04:42 pm, you wrote:
> nobody know if it is possible to have the date in th e same time eache line

I guess there was a reply to syslog. I am sure it's documented in postgresql
manual. Missed that last time..

 Shridhar

Re: command

From
Tom Lane
Date:
Florian Litot <flitot@besancon.sema.slb.com> writes:
> yes it's good but can i have the date with each line?

If you turn it on in postgresql.conf.  See the manual:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.html#LOGGING

            regards, tom lane

Re: command

From
Neil Conway
Date:
"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> On 8 Nov 2002 at 11:03, Florian Litot wrote:
> > yes it's good but can i have the date with each line?
>
> Err.. I don't think so.

Try the log_timestamp GUC option.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

Re: command

From
Medi Montaseri
Date:
I have noted similar problems when attempting to manipulate stdin,
stdout, stderr of postmaster.
So I use pg_ctl -l log
See pg_ctl(1) to see how they do it there.....

Florian Litot wrote:

> What is the command to launch a trace
> i try postmaster -i -D .... -d 10 >logfile
> but the file is create but nothing are in why?
> thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org