From: | Jeff Davis <list-pgsql-general(at)dynworks(dot)com> |
---|---|
To: | "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL GUI |
Date: | 2002-01-03 01:21:41 |
Message-ID: | 0GPC00JLY98N6S@mta6.snfc21.pbi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgsql-general |
> > need a abstractionlayer for accessing tabledescriptions? What if we can
> > just create a connection to another dbs and with just a click create a
> > database, create tables and transfer data into PostgreSQL? Wouldn't that
> > be great?
>
> That would be a very slick feature, but it is also something you can do
> with a 30-second Perl script.
Well, true. You can actually do any task enabled by this software instead by
a 30-second perl script. 30 seconds is fine to complete one task. However,
the process (at least for some people) of creating and modifying a database
structure often involves many steps, and sometimes involves changes of mind.
Graphical clients often can expedite this process by enabling quick results
that help to plan a correct solution. Writing a perl script usually means you
have it already planned out mentally or on paper. A perl interpreter does not
assist in planning in any way.
>
> > What are the special features you would like to see in a
> > PostgreSQL-specific GUI like this? What makes in your eyes the
> > uniqueness of PostgreSQL compared to others?
>
> I'd like:
> * Highlighted output from EXPLAIN
> * A nice display of all constraint triggers
> * Easy modification of tables (which usually means drop/recreate,
> repopulate, re-establish constraints, reindex, and vacuum analyze)
>
Agreed.
Regards,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2002-01-03 01:37:30 | Re: PostgreSQL GUI |
Previous Message | Jeffrey W. Baker | 2002-01-02 19:55:09 | Re: PostgreSQL GUI |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Trombley | 2002-01-03 01:29:54 | Re: SERIAL or INT8 / Unique BLOB's |
Previous Message | Jeffrey W. Baker | 2002-01-03 00:55:11 | Re: SERIAL or INT8 / Unique BLOB's |