Thread: tedia2sql 0.86 Released

tedia2sql 0.86 Released

From
Tim Ellis
Date:
Hello, lists,

I know I've posted about 7 release announcements for tedia2sql, but
features keep getting added! I'll try to keep announcements down to an
every-other-week frequency from now on.

Again, quick tedia2sql summary: Dia UML diagrams converted to SQL DDL for
Postgres, Oracle, DB2, Sybase. Others added as interest is shown. Homepage
at http://tedia2sql.tigris.org -- DBAs should be excited.

Jesus Sandoval writes:
"Very helpful tool tedia2sql, I'm beginning to use it (very easy to
install and use in my redhat 7.3 Linux, everything it needs is already
installed), I use it for Postgresql."

It appears if you run a later Redhat system (and I would assume a Mandrake
system as well), the prerequisites for tedia2sql are already installed.

The latest tedia2sql includes ability to add "RDBMS-specific" SQL,
specifically to allow creation of sequences. This functionality is
generic: you can specify "add this SQL for Postgres and Oracle, but add
that SQL for Sybase and DB2."

At this point, you can create a Dia diagram to give you:

 1. Database schema w/ PK and FK statements
 2. Insert statements to fill tables with initial data
 3. Extra DB constructs like sequences or special stored procs
    & triggers

Cheers,
--
Tim Ellis
DBA, Gamet



meaning of explain

From
Auri Mason
Date:
in order to measure the improve of performances after a vacuum+reindex (do
you suggest something more?), I want to understand exactly the output of
the explain command.
After a google search I found a broken link posted by Tom.

Anyone of you can help me?

TIA, Auri




Re: meaning of explain

From
Stephan Szabo
Date:
On Tue, 9 Jul 2002, Auri Mason wrote:

> in order to measure the improve of performances after a vacuum+reindex (do
> you suggest something more?), I want to understand exactly the output of
> the explain command.
> After a google search I found a broken link posted by Tom.

As a suggestion, vaccum analyze rather than vacuum to get the stats
updated and I'd suggest checking chapter 11 of the user's guide if you're
using 7.2 which appears to have a section on explain.