On Thu, 2006-03-16 at 17:32 +1300, Christopher Sawtell wrote: > On Thursday 16 March 2006 16:04, Roy Britten wrote: > > On Thu, 2006-03-16 at 15:54 +1300, Don Gould wrote: > > > Is there any kind of gui tools that > > > you know of for postgres? > > > > pgAdmin III http://www.pgadmin.org/ > > Also you could use the sql:// protocol in Konqueror. > > imho using these click and point gui tools is a somewhat hazardous > exercise, because they don't, as a general rule, conveniently save a .sql > source code file from which you can rebuild the database from scratch.
In my experience, depending on the scope of the exercise, GUI tools are always useful. They are productivity tools. You want to finish your work and give results as quickly as possible no matter if you are a database developer, admin or analyst. They are also good learning tools. You may not want every bit of work you've done to be saved. Only the end result matters when you're satisfied that you created something useful worth re-using later. Then you want to script the database, the scripts to initialise default values in different tables, administration, analysis and discovery scripts. And a backup eventually with your test data and parameters. Here almost all GUI tools offer scripting options to help with this. At the end of the day they are only script generators with nice colored pictures. Cheers, Adrian
