GDA: Status

[Derek Atkins]

"Albert Lash" <albert.lash at gmail.com> writes:

>>>
>>> One problem with libdbi is that its scope doesn't cover everything that
>>> libgda's does.  From what I can tell, libdbi doesn't have any apis to
>>> cover table/index creation, and that is one area that has a lot of
>>> individuality (e.g. autoinc integer fields).
>>
>> Is that the only individuality?  Or are there others as well?
>> Could we abstract those pieces out ourselves?
>> How do other projects using those technologies handle that?
>
> While not optimal, is it a practical issue? Most SQLite drivers
> automatically create  database if the target doesn't exist (not sure
> about libdbi), and the tables could be created by a "create new file"
> user event.

Sorry, not a question of creating the database..  It's a question
of creating/updating all the GnuCash tables.  For example, the
auto increment column type is different on MySQL v. PG, so we'd
need to know the underlying DB type to know how to create the
table.

> As for MySQL / Postgres, I can't imagine a user sophisticated enough
> to want this who would be unwilling to follow some simple directions
> to install the model.

As I said in my previous message, MythTV already shows how to do
this with MySQL and PG without requiring any user intervention.
I really like their model.  It also allows easy DB model upgrades.

> However, don't take this the wrong way, I'm not advocating we ditch
> gda - I'm leaving that decision up to Phil.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available