MediaWiki and Postgresql?

Hi

pgsql-general-owner@postgresql.org wrote:

Has anyone put MediaWiki up using the current version of Postgresql?

I have, although our Mediawiki installation is currently not openly
accessible. Can't say that it went like a breeze, but the obstacles
where more or less minor and writing a little custom auth-plugin wasn't
really too hard either. If your question was just along the lines of
"does it run", I can confirm that, yes, it does. I cannot say though how
well it would stand up to high loads and if every query and index has
been fully tweaked.

Kind regards

Markus

On Mon, 2006-04-03 at 06:36, Markus Wollny wrote:

Hi

pgsql-general-owner@postgresql.org wrote:

Has anyone put MediaWiki up using the current version of Postgresql?

I have, although our Mediawiki installation is currently not openly
accessible. Can't say that it went like a breeze, but the obstacles
where more or less minor and writing a little custom auth-plugin wasn't
really too hard either. If your question was just along the lines of
"does it run", I can confirm that, yes, it does. I cannot say though how
well it would stand up to high loads and if every query and index has
been fully tweaked.

Given that this page:

http://www.mediawiki.org/wiki/Help:%24wgDBtype

says:

Use ""mysql"" for working code and ""PostgreSQL"" for development/broken
code.

I'd guess that PostgreSQL support is not quite at the same level as
MySQL just yet. :)

On Apr 4, 2006, at 11:08 AM, Scott Marlowe wrote:

On Mon, 2006-04-03 at 06:36, Markus Wollny wrote:

Hi

pgsql-general-owner@postgresql.org wrote:

Has anyone put MediaWiki up using the current version of Postgresql?

I have, although our Mediawiki installation is currently not openly
accessible. Can't say that it went like a breeze, but the obstacles
where more or less minor and writing a little custom auth-plugin
wasn't
really too hard either. If your question was just along the lines of
"does it run", I can confirm that, yes, it does. I cannot say
though how
well it would stand up to high loads and if every query and index has
been fully tweaked.

Given that this page:

http://www.mediawiki.org/wiki/Help:%24wgDBtype

says:

Use ""mysql"" for working code and ""PostgreSQL"" for development/
broken
code.

I'd guess that PostgreSQL support is not quite at the same level as
MySQL just yet. :)

If I'm not confusing wiki's (and I'm offline now, so I can't check),
Mediawiki is pretty un-interested in supporting PostgreSQL (hard to
imagine why, given that some of their folks are paid by MySQL AB), so
a fork was created on pgFoundry. I believe it's called pgpedia.

If I am confusing wiki's, I'm wondering if they'd be willing to
accept patches to improve PostgreSQL support...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

On 4/6/06, Jim Nasby <jnasby@pervasive.com> wrote:
(...)

If I'm not confusing wiki's (and I'm offline now, so I can't check),
Mediawiki is pretty un-interested in supporting PostgreSQL (hard to
imagine why, given that some of their folks are paid by MySQL AB), so
a fork was created on pgFoundry. I believe it's called pgpedia.

That'd be "wikipgedia":
http://pgfoundry.org/projects/wikipedia/

Ian Barwick

On 4/4/06, Scott Marlowe <smarlowe@g2switchworks.com> wrote:
(...)

Given that this page:

http://www.mediawiki.org/wiki/Help:%24wgDBtype

says:

Use ""mysql"" for working code and ""PostgreSQL"" for development/broken
code.

The documentation in the MediaWiki wiki isn't always up to date, I suspect.

I'd guess that PostgreSQL support is not quite at the same level as
MySQL just yet. :)

FWIW there's a file "includes/DatabasePostgreSQL.php" in the CVS head
versions of MediaWiki which has at the top:

/**
* This is PostgreSQL database abstraction layer.
*
* As it includes more generic version for DB functions,
* than MySQL ones, some of them should be moved to parent
* Database class.
*
* STATUS: Working PG implementation of MediaWiki
* TODO: Installer support
*
* @package MediaWiki
*/

(There's also "includes/DatabaseOracle.php" but it doesn't say
anything about status).

Ian Barwick

On Thursday 06 April 2006 16:45, Jim Nasby wrote:

On Apr 4, 2006, at 11:08 AM, Scott Marlowe wrote:

On Mon, 2006-04-03 at 06:36, Markus Wollny wrote:

Hi

pgsql-general-owner@postgresql.org wrote:

Has anyone put MediaWiki up using the current version of Postgresql?

Most of the code I have seen has been run against pg 8.0.x or 8.1.x; generally
pg isnt the problem in this equation.

I have, although our Mediawiki installation is currently not openly
accessible. Can't say that it went like a breeze, but the obstacles
where more or less minor and writing a little custom auth-plugin
wasn't
really too hard either. If your question was just along the lines of
"does it run", I can confirm that, yes, it does. I cannot say
though how
well it would stand up to high loads and if every query and index has
been fully tweaked.

I know a few people running postgresql based mediawiki installations and it
seems to hold up pretty nicely. These folks aren't running the same code you
would find at the core mediawiki project, but instead they are using
patched/modified code to get things working. A fairly runnable copy is the
0.0.3 release of wikipgedia, though it too needs a few security updates from
the core project. You could probably get the cvs code working again, though
it needs testing and probably some fixes.

Given that this page:

http://www.mediawiki.org/wiki/Help:%24wgDBtype

says:

Use ""mysql"" for working code and ""PostgreSQL"" for development/
broken
code.

I'd guess that PostgreSQL support is not quite at the same level as
MySQL just yet. :)

I think this is a fairly good summary of things:
http://lists.pgfoundry.org/pipermail/wikipedia-news/2006-February/000017.html

If I'm not confusing wiki's (and I'm offline now, so I can't check),
Mediawiki is pretty un-interested in supporting PostgreSQL (hard to
imagine why, given that some of their folks are paid by MySQL AB), so
a fork was created on pgFoundry. I believe it's called pgpedia.

If I am confusing wiki's, I'm wondering if they'd be willing to
accept patches to improve PostgreSQL support...

You are not. I dubbed the new code wikipgedia, it lives on the foundry, the
home page is at http://wikipedia.projects.postgresql.org/. We would love to
have some new contributors. I hope to give another go around at making the
code production ready, but it involves the properly shaped tuits, and I don't
have a database company paying me to work on it :-)

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL