[wikka-community] WikkaWiki on MicroSQL database?

[Brian Koontz]

On Fri, Jan 30, 2009 at 11:10:29AM -0500, Leon wrote:
> What would it take to run WikkaWiki on a MicroSoft SQL database?

Probably quite a bit of work, I'm afraid.  The Wikka core uses the
built-in MySQL functions that PHP provides.  Hindsight always being
20/20, it would have been prudent for Wikka to have provided a DB
abstraction layer (such as ADOdb) to permit interfacing with any
number of databases.

I notice PHP supports a family of MSSQL functions...it's *conceivable*
one could replace the mysql_ calls with mssql_ calls, but I would
imaging there would be formatting issues to content with, since
everyone thinks their flavor of SQL is the best.  And the work
involved with this would probably be better spent on abstracting the
database layer.

We're slated to look at this for 1.2
(http://wush.net/trac/wikka/ticket/171), but that is most likely
several months away.   You might also get some inspiration from this
link:

http://wikkawiki.org/DatabaseAbstraction

  --Brian

--
Brian Koontz
Wikka Development Team
Systems Support and Random Tasking Dept.