Re: [gnome-db] Re: GdaParameter Status/Usage

[Rodrigo Moya <rodrigo gnome-db org>]

On Thu, 2001-12-27 at 14:46, Adam Williams wrote:
> >So, if nobody thinks there can be problems with this :... thing, we'll
> >go with this one.
> >Anyway, first of all, we need a simple SQL parser:
> >http://bugzilla.gnome.org/show_bug.cgi?id=67343
> >anyone volunteers? :-)
> 
> The unixODBC project has the SQP library which is a lexx/yacc based SQL 
> parser for use in building ODBC drivers for non-SQL data sources.  They've 
> broken in out of the entirity of unixODBC so that other 
> application/projects can use it.
> 
> They also have the SQI library which is a light weight SQL engine for use 
> with text files, it uses SQP.  Once upon a time KDE used SQI to access 
> it's configuration files.  I don't know if this is true anymore as I'm now 
> a GNOME bigot.
> 
this is very nice to know. I should have known about this before :-)
This makes a lot of sense for libgda, where we'll use this stuff a lot,
and, for the default provider (see below)

> I don't know if any of this is applicable to GNOME-DB,  but I'd hate for 
> anyone to spend time re-inventing the wheel.
> 
> Also, GNOME-DB ships with SQLlite (which I love) and that *obviously* must 
> contain and SQL parser.  Maybe that could be broken out since it is 
> "included" anyway.
> 
SQLite is included into libgda as the result of one of my quick
solutions :-) That is, I added a default provider, and found out SQLite
was the best choice for it, so as there were not SQLite packages at that
time in almost no distribution, I included its sources into libgda's.

But, this is not the ideal solution, the current gda-default provider
should be just a gda-sqlite provider, as the rest of providers. And the
default one should be one using our own "engine", which, for sure, will
now be the unixODBC libs you talk about.

So, ideally:
* SQlite sources will be removed from libgda's (of course, as soon as we
can make sure SQLite is available in many distributions. In the
meantime, we can just continue including them with our sources.

* the default provider will be moved to be called gda-sqlite

* the new default provider will use the unixODBC libs

* we'll write a GdaSqlParser class which uses SQP

does that make sense?

cheers

-- 
Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com>
http://www.gnome-db.org/ - http://www.ximian.com/