Today several developers prioritized, closed, or followed up on eleven
database bugs, and discussed how to improve support for non-MySQL
databases in MediaWiki. The details are in the notes:
https://www.mediawiki.org/wiki/Bug_management/Triage/Databases_20111102
with summaries in the comments on each bug.
Microsoft's Ben Lobaugh volunteered to lead an effort towards automated
testing on non-MySQL databases in the Wikimedia Labs infrastructure, and
additional infrastructures as necessary. He'll help us get some Windows
machines, or a setup in a Microsoft-run Azure cloud, so we can test on
Microsoft SQL Server properly.
How you can help MediaWiki administrators who don't use MySQL:
* Write tests or specs. Ben and DJ Bauch want to work on better unit
testing per
https://bugzilla.wikimedia.org/show_bug.cgi?id=32118
(special page SQL queries), and could use specifications to test
against. Improve
https://www.mediawiki.org/wiki/Database_testing .
* Try to reproduce this installation failure on SQLite or PostgreSQL:
https://bugzilla.wikimedia.org/show_bug.cgi?id=28172
* Fix "Database layer should automagically add GROUP BY columns on
backends that need them (postgres)"
https://bugzilla.wikimedia.org/show_bug.cgi?id=26273 . This is a large
project.
* Make a meta-schema so that we no longer use tables.sql as a canonical
source. Chad and Max started in
http://svn.wikimedia.org/viewvc/mediawiki/branches/abstract-schema/ .
See
https://www.mediawiki.org/wiki/Bug_management/Triage/Databases_20111102#Ide…:
for more discussion. This is a large project.
--
Sumana Harihareswara
Volunteer Development Coordinator
Wikimedia Foundation