Best GPLike ERD/SQL developing tool for postgresql?

From: Wim Bertels <wim(dot)bertels(at)khleuven(dot)be>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Best GPLike ERD/SQL developing tool for postgresql?
Date: 2010-12-14 11:15:08
Message-ID: 1292325308.2060.94.camel@zwerfkat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hallo,

i have tested some tools,
but none of them have the all the functionality i'm looking for:

(erd/sql(/db))
- forward engineer SQL (to db (and uncluttered erd))
- backward engineer SQL (to sql and uncluttered erd)
- compare

- autocompletion when writing code

(erd)
- full postgresql support (eg datatypes)

(erd)
- full constraints support (eg composite keys, unique..)

My best candidates i found so far for linux-systems
- pgDesigner (not stable though, crashes regularly, no support for
higher postgresql versions, no autocompletion, ..)
- squirrel (no engineering starting from a erd, only for printing, )
- executeQuery (no full constraints support when creating erd, which
works, but not so user friendly)
- power*architect (in my opinion the best look and feel, but lacks a lot
of features)
(- sql workbench (no erds!))
Combining the strengths of each these would be a good developing tool
though.

Any suggestions with regard to good gplike erd/sql developing tools for
postgresql?
No mails about proprietary or closed source tools plz.

mvg,
Wim

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2010-12-14 11:39:41 Re: create language 'plpythonu' on win failed
Previous Message Vincent Veyron 2010-12-14 11:12:48 Re: range intervals in window function frames