Re: What is your favorite front end for user interaction to postgresql databases?

I agonized over this decision when I migrated my application to PostgreSQL.  I know Tony Caduto likes Delphi and he can give some good reasons for this (are you out there, Tony?).  There has also been a good article recently about Ruby on Rails.  For my purposes, I wanted to maximize cross-platform compatibility and decided on Java.  I was advised (correctly, I think) to opt for SWT rather than standard Java Swing and ended up with Eclipse.  I must say that Eclipse has not been particularly easy to learn - the documentation is quite uneven and the mail lists aren't nearly as helpful as with the PostgreSQL community.  Also, Eclipse is changing so quickly that books have a hard time keeping up.  Nevertheless, it is powerful and I've found it rewarding.  To make things easier for others, I uploaded a basic Eclipse front end (without editors, views, and reports) to pgFoundry (Komo PostgreSQL Client).

 

On the second question, I also like to have the database do as much of the work as possible. 

 

Michael Schmidt