GDA: Status

[Phil Longstaff]

Derek Atkins wrote:
> Phil Longstaff <plongstaff at rogers.com> writes:
> 
> My appologies for sounding like a broken record, but if you look at
> MythTV they show how to support both MySQL and PG in an automated
> fashion.  At least I'm pretty sure they can create and update tables
> for both DBs.

I'll take a look at MythTV.  The only places I had looked at were from
links on the libdbi website.

> We should have a plan in place at day 1 for how we'd deal with this.
> I DO like the MythTV model where we have a DB Schema Version number
> in a known table/location and then we can use that to detect whether
> we need updates.

I recently added a version number per table.  At a minimum, we would
need 1 for core and 1 for business.

>> 4) switch gda calls to dbi calls
>> 5) lots more.
> 
> "think you should be more explicit here in step two"  (okay, step 5).
> What's "lots more" here?
> 
>> I think what I want to do is create a dbi backend in the gda-dev2 tree,
>> copy the gda code over, and just see what would be required to modify
>> everything.  That would give me a feel for the amount of effort required
>> to switch.
> 
> Do you want to do this in the gda-dev or would you like a new branch
> to work from?   Branches are cheap.

At this point, I'll work in gda-dev.

Phil