Re: Fetature enhancement request : use of libgda in PostgreSQL to access legacy databases.

Le Lundi 11 Février 2002 10:12, Andrea Aime a écrit :
> did you notice http://gasql.sourceforge.net in the applications section
> of the gnome-db site? It is supposed to be a PostgreSQL administration
> tool, and seems to be nice looking at the screenshots... maybe you
> just need to remove GNOME integration...
> Just my 2 cents :-)

Dear Andrea,

The purpose of my last mail was to propose the integration a libgda client 
into PostgreSQL. For example, it should be possible to attach an Oracle table 
into PostgreSQL, with the ability to run SELECTs, UPDATEs and maybe JOIN 
queries (???).

This is pure computer-fiction, but MySQL might well provide such feature as 
well and query PostgreSQL objects...

Coming back to gasql, if we happen to port pgAdmin2 
(http://pgadmin.postgresql.org) to Linux, why not use libgda and create a 
multi-vendor GUI directly.

People were discussing lately about adding SQL compatibility layers in 
PostgreSQL (i.e Oracle compatibility). IMHO, this is not the right direction 
to go first because it would demand too much investment.

On the converse, if we integrate libgda BOTH into PostgreSQL AND in a future 
GUI client, we are winning.

Just my 2 cents. My opinion is that the community should concentrate on real 
issues, starting with the most needed ones (ALTER TABLE ALTER COLUMN, CREATE 
OR REPLACE VIEW, CREATE OR REPLACE TRIGGER) and then work on GUI tools and 
abstraction layers to open PostgreSQL to the world.

Just my 2 cents. What do you think my friends?

Cheers,
Jean-Michel POURE