plongstaff at rogers.com
Wed Jun 4 12:02:04 EDT 2008
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.
More information about the gnucash-devel