Re: [gnome-db] questions related to the SQL parser

[Andrew Hill <andru treshna com>]

Fernando Martins wrote:

> Hi!
>
> I was reading the posts regarding the SQL parser and I've a few questions:
>
> - will the libgda providers be able to use this parser to read standard SQL
> 99 and convert it to the proper dialect?
i'm only working on SQL92 implimention initially.  But other said they would
work on SQL99.  It wont convert it to native dialects for each database 
but build a
compressive strcutre in memory about the SQL statement which can then
be used to recreate the sql query string.  You could theoritiy from this 
make it be
able to handle different dialects.

> - I thought gnome-db was using sqlite http://www.hwaci.com/sw/sqlite/ This
> already includes a parser (besides the engine). What's wrong with it?
I've heard of it but havn't seen the source code for it yet.

> - also, there is a GTK+ based project with a (very incomplete) SQL parser
> and engine http://mdbtools.sourceforge.net/ Had you seen it?
I started work on a sql parser a few months ago which is mostly 
functional, its easier
for me to rework my own code than rework someone elses.

> BTW, the main goal of this last project is to read MS Access MDB files. This
> in itself would be a killer feature to gnome-db...
A sql parser and a database engine are 2 different things.  I imagine 
they will write
a sql databse engine ontop of the MDB file and use the MDB as flat file 
storage.
If you wanted to support mdb files in gnome-db it would be more sensible 
to add
mdbtools as a gda provider, not merge the projects.

> regards,
>
> Fernando Martins
>
>
> _______________________________________________
> gnome-db-list mailing list
> gnome-db-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnome-db-list
>
>
>