| 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: | Whole Thread | Raw Message | 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 |