Quoting Adrian Mageanu <[EMAIL PROTECTED]>:
> 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.
Just my two cents worth - I did a lot of database learning courtesy of Gupta
and their SQLWindows. It was a "pretty-picture generator", but it also
connected to servers. And it was more robust than MS Windows.
But then, I also got CJ Date's "An Introduction to Database Systems"; and if
anything cures one of addiction to pretty picture generators, that book is it.
Thoroughly recommended for getting your head around relational database system
concepts.
Wesley Parish
>
> 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
>
>
"Sharpened hands are happy hands.
"Brim the tinfall with mirthful bands"
- A Deepness in the Sky, Vernor Vinge
"I me. Shape middled me. I would come out into hot!"
I from the spicy that day was overcasked mockingly - it's a symbol of the
other horizon. - emacs : meta x dissociated-press
