Re: [gnome-db] V3 vs V4

["Vivien Malerba" <vmalerba gmail com>]

On Sat, May 31, 2008 at 8:21 PM, Phil Longstaff <plongstaff rogers com> wrote:
> For the past few weeks, I've ported my code from V3 to V4.  My findings:
>
> 1) the sqlite provider for V4 seems to be in pretty good shape.  I've
> found and fixed a number of memory leaks, but on the whole, I can use
> it.  I have an operation to create an index which crashes, but I don't
> know if the problem is mine or in libgda, and need to chase it down.
>
> 2) the mysql provider is missing a lot.  when I look for try to update
> the meta_store, all of the mysql routines report that they are not
> implemented.  in addition, when I inquire whether a table exists or not,
> it returns that it does not, so when I try to create it, it fails
> because it already exists.  In addition, as I reported in a previous
> posting, I need a mechanism to return the correct string dbms type based
> upon string length.

This provider still needs some work...

>
> 3) I haven't tried the postgresql provider yet.
>

This provider is as stable and correct as the Sqlite one.

> I need to make a decision soon whether to stick with V4 or revert back
> to V3, or possibly switch to a different db backend provider.  What is
> the future of GDA-3 vs GDA-4?  What is the expected timing for GDA-4?
> Will there by any more GDA-3 releases while V4 is being worked on?  I
> understand that this is a volunteer project, but can you say anything
> about what I, a volunteer on another project, can expect?

I don't expect to make any more release of the V3. The V4 is now
almost API stable (I just want to introduce an api for the two phase
commits). I'll make some other releases before it is actually stable,
though.
I envision a stable V4 release of Libgda around the end of the summer
(just to be n the safe side). That stable release will have database
providers for at least SQLite, MySQL and PostgreSQL (and maybe Oracle
if I have the time).

Also I would like to propose libgda (and maybe libgnomedb) as part of
the Gnome platform for the next Gnome release (it will be for the
2.26).

Of course I'll be glad to help you with any problem you'll encounter
with libgda.

So you can expect some support from me and a stable library by the end
of the summer. If there is a feature you'd need before makin a stable
release, please tell me.

Regards,

Vivien