On Mon, Jul 05, 2004 at 03:36:33PM +0000, Volker Hetzer wrote:
Hi! We are thinking of setting up a wiki in our department and are looking at the different wikis out there. However, one requirement is that it must run on oracle, for a variety of reasons. (I'd like to avoid a discussion of how I am supposed to convince my boss to install a second, isolated database in the department.) Has anybody already managed to get the mediawiki running on an oracle db? Can anybody think offhand of any problems that might arise? Right now the only thing that comes to my mind is BLOB handling, which is slightly different in oracle. Anything else?
MySQL has some strange "enhancements" to SQL that are not compatible to the rest of the world. With dammit's port to PostgreSQL, these spots were identified and using a global ($wgIsPg I think it's named) the MySQL-specific instructions can be disabled. This should be a good starting point for a port to Oracle. PostgreSQL handles sequences the same way Oracle does, so that our usage of MySQL's auto_increment columns has already been ported, too. The PostgreSQL port is in the latest 1.3 betas.
Regards,
JeLuF