Mailbox-Line: From rtreat@webmd.net  Fri Jun 28 12:14:33 2002
Subject: Re: graphical interface - admin
From: Robert Treat <rtreat@webmd.net>
To: David BOURIAUD <david.bouriaud@ac-rouen.fr>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <200206271434.45443.david.bouriaud@ac-rouen.fr>
References: <3D1AFBF1.6060303@sni.ph>
	<200206271434.45443.david.bouriaud@ac-rouen.fr>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Date: 28 Jun 2002 11:44:45 -0400
Message-Id: <1025279088.1709.47.camel@camel>
Mime-Version: 1.0

I'd love to see this as much as anyone, but if you're going to do it imo
the main feature most people would be interested in is some type of ERD
diagramming that can also be used for database administration (yes,
basically a clone of M$ Access, but with more native support). This is
the one thing I'd really like to add to phpPgAdmin, but the web isn't
the best medium for those types of things, and quite frankly I haven't
had the time to really look into it. OpenOffice comes close with it's
graphical query builder, but afaik it doesn't quite have the ability to
layout tables/relationships as well. Last time I checked PGAccess was
lacking in this area as well. If your serious about starting another
project I'd strongly recommend you search on sourceforge first as there
are several projects there than can help you out. You should definitely
take a look at dbdesigner, which is a KDE based (and I'd assume C++)
admin tool that has postgres support. Stand on the shoulders of others
right?

Robert Treat

On Fri, 2002-06-28 at 02:38, David BOURIAUD wrote:
> Le Jeudi 27 Juin 2002 13:50, q u a d r a a =E9crit :
> > What's the best open source GUI for DB administration? (postgres)
> Why ? Mine of course !
>=20
> Noway for this stupid answer !
> Well, I would say that you have at least two choices amongst those I know=
 :
> phpPgAdmin, which works as it's name says with php, and one that is calle=
d=20
> pgaccess and which is brought along with the sources of postgreSQL, and w=
hich=20
> is written in tcl/tk (as far as I know).
>=20
> Anyway, neither of them fits my needs. You also have commercial solutions=
,=20
> like creating a linked db with msAccess (using ODBC), or BO (orientated f=
or=20
> editions). Anyway, you've got many choices.
>=20
> As for what I first said in this mail, I'll launch the development of a K=
de=20
> application (I think called KPostgreSQL...), which will have to fit the=
=20
> following :
>=20
> -Ability to open as many DB connections as possible in one MDI frame (as =
you=20
> can open many documents in KAte).
> -Graphical interface for all the administrative tasks (tables creations,=
=20
> permissions...) nearly as Access does.
> -Intelligent queries (at requests), which are able to do autimatic joins =
(as=20
> far as they are created at table creation time).
> -Nice editions made with LaTeX, providing there are classes made.
> -etc...
> In the future, when I get a full comprention of KParts, it may be integra=
ted=20
> with KWords and all the Koffice suite (I mean, you could embed a query in=
=20
> KSpread, and so on...).
> That's what I plan to do, all in C++, and only for Kde. When the project =
will=20
> be far enough, I'll open the sources, using CVS I think, and enjoy my tim=
e=20
> coding and maybe recieving help. Whatever happens in the future, I WANT t=
o=20
> code this, and will work on it since I need it.
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>=20
> --=20
> David BOURIAUD
> ----------------------------------------------------------
> In a world without walls or fences, what use do we have=20
> for windows or gates ?
> ----------------------------------------------------------
> ICQ#102562021
>=20
>=20
>=20
>=20
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>=20