Hi Robert

As far as I understand, MediaWiki does not use stored procedures, for compatibility reasons. MediaWiki only requires mysql 4.0, which iirc does not support stored procedures at all. Also, stored procedures can not (easily) be ported to other database systems like sqlight.

If you want to use stored procedures in your extension, I don't see anything mediawiki specific to observe. It should works simply as you would expect it from mysql. The only question is how the procedures can be created cleanly when the extension is being installed, or changed when the extension is updated. Perhaps someone here knows about this?

A quick search through the extensions on mediawiki.org indicates that Extension:Geoserver uses stored procedures, but with postgres, not mysql.

hth daniel

On 05.08.2011 11:37, Robert Vogel wrote:

Hi Brion,

thanks for the hint. Is there a tutorial or documentation on how to use stored procedures in MediaWiki? Do you - or anybody else - know an extension that makes use of this feature? Something we can take a look at?

Greetings,

Robert Vogel Hallo Welt! - Medienwerkstatt GmbH

---

Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l