Mailbox-Line: From david.bouriaud@ac-rouen.fr  Fri Jun 28 02:32:08 2002
Content-Type: text/plain;
  charset="iso-8859-1"
From: David BOURIAUD <david.bouriaud@ac-rouen.fr>
Organization: Inspection =?iso-8859-1?q?acad=E9mique=20de?= l'Eure
To: pgsql-sql@postgresql.org
Subject: Re: graphical interface - admin
Date: Fri, 28 Jun 2002 08:38:34 +0200
References: <3D1AFBF1.6060303@sni.ph>
In-Reply-To: <3D1AFBF1.6060303@sni.ph>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200206271434.45443.david.bouriaud@ac-rouen.fr>

Le Jeudi 27 Juin 2002 13:50, q u a d r a a écrit :
> What's the best open source GUI for DB administration? (postgres)
Why ? Mine of course !

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 called 
pgaccess and which is brought along with the sources of postgreSQL, and which 
is written in tcl/tk (as far as I know).

Anyway, neither of them fits my needs. You also have commercial solutions, 
like creating a linked db with msAccess (using ODBC), or BO (orientated for 
editions). Anyway, you've got many choices.

As for what I first said in this mail, I'll launch the development of a Kde 
application (I think called KPostgreSQL...), which will have to fit the 
following :

-Ability to open as many DB connections as possible in one MDI frame (as you 
can open many documents in KAte).
-Graphical interface for all the administrative tasks (tables creations, 
permissions...) nearly as Access does.
-Intelligent queries (at requests), which are able to do autimatic joins (as 
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 integrated 
with KWords and all the Koffice suite (I mean, you could embed a query in 
KSpread, and so on...).
That's what I plan to do, all in C++, and only for Kde. When the project will 
be far enough, I'll open the sources, using CVS I think, and enjoy my time 
coding and maybe recieving help. Whatever happens in the future, I WANT to 
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

-- 
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have 
for windows or gates ?
----------------------------------------------------------
ICQ#102562021