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