From mla@gams.co.at
Received: (qmail 31991 invoked from network); 9 Aug 1998 20:00:16 -0000
Received: from mario.gams.at (194.42.96.10)
  by mail2.redhat.com with SMTP; 9 Aug 1998 20:00:16 -0000
Received: from bononunu.gams.co.at (mail.gams.co.at [193.46.232.10])
	by mario.gams.at (8.8.5/8.8.5) with ESMTP id VAA21202;
	Sun, 9 Aug 1998 21:59:46 +0200
Received: from loki.gams.co.at (loki.gams.co.at [193.46.232.130]) 
by bononunu.gams.co.at (8.7.1/8.7.3) with ESMTP id VAA10064; 
Sun, 9 Aug 1998 21:59:45 +0200
Received: from loki.gams.co.at (localhost [127.0.0.1])
	by loki.gams.co.at (8.8.5/8.8.5) with ESMTP id VAA30228;
	Sun, 9 Aug 1998 21:59:43 +0200
Message-Id: <199808091959.VAA30228@loki.gams.co.at>
To: spacey@inch.com, cknite@danville.net, adam@pingpage.com
cc: gnome-list@gnome.org
Subject: gnome-db 0.2 is ready
Date: Sun, 09 Aug 1998 21:59:42 +0200
From: Michael Lausch <mla@gams.co.at>


It adds iodbc support and therefore another databse driver, the
postgres ODBC driver.

I was able to connect to a postgres database with this application.

Problems:

1) Gnome independency of the lower level stuff
   I don't think this is possible wihtout too much code
   duplication. The Driver Manager has to access a ini file which is
   in the infamous MS INI file syntax (same as the gnome ini
   files). Either write another parser or use the Gnome parser.
   This ini file shoudl also be editable with a gnome utility, the
   `gnodbc manager'. Therefore it's the best thing to keep the syntax
   of the odbc.ini file the same as the other gnome ini files.

1a) There eixts one function SQLBrowseConnect which opens dialog
    windows to gather missing parameters for a database access from the
    user. It would be nice if we could utilize this. The problem is that
    some of the functionality must even be provided by the real ODBC
    driver. the driver manager has not enough knowledge to know which
    parameter is needed by the driver to do the connect.

1b) The cursor value passing problem. A DB cursor can be a data sink or 
   a data source. In either situation it musr request that data is
   availebale or that the cursor is able to process further data. This
   can easily ve implemented using Gtk's signal mechanism. I don't see 
   a reason to reimplement signals or callbacks , only for the sake of
   being gnome dependent. KDE has it's own ODBC package anyway (C++
   based). 

2) Wrong SQL operations the query functions for DB metadata shoudl be
   done using standard ODBC functions, bnot the current wayt (it is ugly, 
   non correct and non portable).

3) Better layering. The current distribution of functionality between
   different source files and libraries is a mess. This will be
   tackled in the next release, so that it's easier to develop the GUI 
   part independent from the other part.

4) the login widget is a hack gnome-db-login.[ch].

5) The iodbc licence. iodbc is only GPL, but we need it to be LGPL (i
   think). I already wrote the owner of iodbc if he's willing to
   change the licence. If he isn't we have to re-implement iodbc. Not
   that this is hard, but tedious.
--
Michael Lausch/g.a.m.s. edv dienstleistungen gmbh
See my web page <http://www.gams.net/~mla> or query PGP key server for PGP key.
"Reality is that which, when you stop believing in it, doesn't go away".
                -- Philip K. Dick

From miguel@nuclecu.unam.mx
Received: (qmail 29587 invoked from network); 10 Aug 1998 17:19:45 -0000
Received: from athena.nuclecu.unam.mx (132.248.29.9)
  by mail2.redhat.com with SMTP; 10 Aug 1998 17:19:45 -0000
Received: (from miguel@localhost)
	by athena.nuclecu.unam.mx (8.8.7/8.8.7) id MAA04758;
	Mon, 10 Aug 1998 12:19:26 -0500
Date: Mon, 10 Aug 1998 12:19:26 -0500
Message-Id: <199808101719.MAA04758@athena.nuclecu.unam.mx>
From: Miguel de Icaza <miguel@nuclecu.unam.mx>
To: mla@gams.co.at
CC: spacey@inch.com, cknite@danville.net, adam@pingpage.com,
        gnome-list@gnome.org
In-reply-to: <199808091959.VAA30228@loki.gams.co.at> (message from Michael
	Lausch on Sun, 09 Aug 1998 21:59:42 +0200)
Subject: Re: gnome-db 0.2 is ready
X-FileLength: are infinite where infinity is set to 255 characters


> It adds iodbc support and therefore another databse driver, the
> postgres ODBC driver.
> 
> I was able to connect to a postgres database with this application.

Where can we get this?

Miguel.

From miguel@nuclecu.unam.mx
Received: (qmail 31413 invoked from network); 10 Aug 1998 17:20:23 -0000
Received: from athena.nuclecu.unam.mx (132.248.29.9)
  by mail2.redhat.com with SMTP; 10 Aug 1998 17:20:23 -0000
Received: (from miguel@localhost)
	by athena.nuclecu.unam.mx (8.8.7/8.8.7) id MAA04761;
	Mon, 10 Aug 1998 12:19:53 -0500
Date: Mon, 10 Aug 1998 12:19:53 -0500
Message-Id: <199808101719.MAA04761@athena.nuclecu.unam.mx>
From: Miguel de Icaza <miguel@nuclecu.unam.mx>
To: mla@gams.co.at
CC: spacey@inch.com, cknite@danville.net, adam@pingpage.com,
        gnome-list@gnome.org
In-reply-to: <199808091959.VAA30228@loki.gams.co.at> (message from Michael
	Lausch on Sun, 09 Aug 1998 21:59:42 +0200)
Subject: Re: gnome-db 0.2 is ready
X-Windows: Flakey and built to stay that way.


> 5) The iodbc licence. iodbc is only GPL, but we need it to be LGPL (i
>    think). I already wrote the owner of iodbc if he's willing to
>    change the licence. If he isn't we have to re-implement iodbc. Not
>    that this is hard, but tedious.

Why do we need to make it LGPL?

Miguel.

From tlewis@mindspring.net
Received: (qmail 2764 invoked from network); 10 Aug 1998 17:37:09 -0000
Received: from camel7.mindspring.com (207.69.200.57)
  by mail2.redhat.com with SMTP; 10 Aug 1998 17:37:09 -0000
Received: from reflections.eng.mindspring.net (reflections.eng.mindspring.net 
[207.69.192.100])
	by camel7.mindspring.com (8.8.5/8.8.5) with SMTP id NAA15063;
	Mon, 10 Aug 1998 13:36:48 -0400 (EDT)
Date: Mon, 10 Aug 1998 13:37:43 -0400 (EDT)
From: Todd Graham Lewis <tlewis@mindspring.net>
X-Sender: tlewis@reflections.eng.mindspring.net
To: Miguel de Icaza <miguel@nuclecu.unam.mx>
cc: gnome-list@gnome.org
Subject: Re: gnome-db 0.2 is ready
In-Reply-To: <199808101719.MAA04761@athena.nuclecu.unam.mx>
Message-ID: <Pine.LNX.3.96.980810133722.24172C-100000@reflections.eng.mindspring.net>
Return-Receipt-To: tlewis@mindspring.net
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Mon, 10 Aug 1998, Miguel de Icaza wrote:

> > 5) The iodbc licence. iodbc is only GPL, but we need it to be LGPL (i
> >    think). I already wrote the owner of iodbc if he's willing to
> >    change the licence. If he isn't we have to re-implement iodbc. Not
> >    that this is hard, but tedious.
> 
> Why do we need to make it LGPL?

Commercial applications need database access too, Miguel.

--
Todd Graham Lewis                                     (800) 719-4664, x2804
******Linux******         MindSpring Enterprises      tlewis@mindspring.net