Обсуждение: MediaWiki and Postgresql?
The propaganda at MediaWiki is sorta vague on Postgresql support. Has anyone put MediaWiki up using the current version of Postgresql? Jerry
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. :) > Kind regards > > Markus > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org
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