Forum OpenACS Q&A: Dual db development

Collapse
1: Dual db development
Posted by Ola Hansson on 02/17/03 08:34 PM
Hi,

I am curious about how folks in general handle simultaneous development on PostgreSQL and Oracle.

If you were developing a package that would support both dbs, how would you rig your dev environment?

It would be pretty nice, for instance, to be able to work on just one single openacs checkout, but I'm not quite sure of the right approach...

Do you all have some tips or tricks?

Thanks!

Collapse
2: Re: Dual db development (response to 1)
Posted by Dave Bauer on 02/17/03 08:48 PM
I do just that. There is no reason to use a different code base for each database. Just put the queries in the right place.

If you have enough RAM you can even run oracle and postgresql at the same time, but I usually stop the database before switching.

All you need to switch is different AOLserver config files to point to the correct database.

Collapse
3: Re: Dual db development (response to 2)
Posted by Jeff Davis on 02/17/03 09:00 PM
I work with one checkout as well, although I had to create a
second acs-content-repository directory since I was working on
CR stuff stored in the filesystem.