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
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 |