Re: PG-friendly CASE/modeling tool?

Lists: pgsql-general
From: Michael C Rosenstein <mcr(at)mdibl(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: PG-friendly CASE/modeling tool?
Date: 2010-08-11 17:17:48
Message-ID: 4C62DB3C.9030104@mdibl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hello. We are new to Postgres, and are in the process of migrating our
project's app from Oracle.

I have been using Embarcadero's ER/Studio as a data modeling/DDL tool
for >15 years (and love it!), but its support for Postgres 8.4 is weak
(e.g., missing many datatypes, no function-based indexes, no partial
indexes, etc, etc). I don't get the impression that they're in a rush to
improve it, either.

Can anyone recommend a mature modeling/CASE tool with good support for
recent Postgres features?

Thanks much!

/mcr

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Michael C Rosenstein <mcr(at)mdibl(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PG-friendly CASE/modeling tool?
Date: 2010-08-11 17:42:18
Message-ID: 1281548538.9354.4.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Wed, 2010-08-11 at 13:17 -0400, Michael C Rosenstein wrote:
> Hello. We are new to Postgres, and are in the process of migrating our
> project's app from Oracle.
>
> I have been using Embarcadero's ER/Studio as a data modeling/DDL tool
> for >15 years (and love it!), but its support for Postgres 8.4 is weak
> (e.g., missing many datatypes, no function-based indexes, no partial
> indexes, etc, etc). I don't get the impression that they're in a rush to
> improve it, either.
>
> Can anyone recommend a mature modeling/CASE tool with good support for
> recent Postgres features?

Eclipse has great modeling tools that work with PostgreSQL.

JD

>
> Thanks much!
>
> /mcr
>
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt