Reliable PostgreSQL IDE/Database Developer Tool

views:

answers:

+1 Q:

Reliable PostgreSQL IDE/Database Developer Tool

Can someone recommend a great IDE/Database Developer Tool for Postgres 8.4. We are currently using EMS SQL Manager but it has so many bugs and shortcomings that its getting on my nerves. I reported the bugs to EMS but they have not been fixed yet.

I wonder what do people use for PostgresSQL development? Windows/Linux, commercial/free, standalone/eclipse plug-in, it does not matter as much. I just want a reliable tool that works and does not blow up in my face.

On PostgreSQL DB we do and would like to have IDE support for.

Tables, views, indexes, triggers
SQL, plpgsql, and python procedures that return single values, set of values or tables
SQL query and performance monitoring
DB role management
Good transaction support straight from GUI as well as support for BEGIN, COMMIT, etc

Any recommendations are welcome.

pgAdmin is a popular one. It's free, and it runs on Windows and Linux. It's been a while since I have used it but I found it to be quite stable. Wasn't fond of the procedure code editor - it worked, I just didn't like it (but now I can't remember why, it was probably a minor thing).

FrustratedWithFormsDesigner 2010-07-15 21:08:03

pgAdmin is a great tool for whats its worth (free, that it), but it is far from full IDE. Its object editor is just a dialog. How do you supposed to develop in a dialog? Code completion is absent. Its better that text editor + psql shell but far from full development environment.

xsaero00 2010-07-15 22:08:04

Actually, code completion sort of exists, but you have to turn it on in the options menu. In latest version you also have the graphical interfce to quickly whip up some code that you can elaborate on afterwards using the editor. Update: autocompletions using TAB: http://www.pgadmin.org/docs/1.10/options-tab3.html

John P 2010-07-16 10:45:55

ansaurus

tags:

views:

answers:

Reliable PostgreSQL IDE/Database Developer Tool

related questions