On Fri, Sep 3, 2010 at 2:44 PM, Chad innocentkiller@gmail.com wrote:
Given those criteria, I think that the following have "full support" in MediaWiki:
- MySQL
- SQLite
- PostgreSQL
In practice, though, SQLite and PostgreSQL are more likely to break than MySQL, right? If so, we should make this clear in the installer UI. Or are they really about as well-supported as MySQL these days, minus a moderate lag in schema updates for pgsql?
Ideally, we could run test suites by default on all available DBs instead of just on the one the wiki currently uses. In particular, SQLite currently uses the same schema as MySQL and is available in PHP by default, plus it doesn't require any setup (providing admin login, etc.), so it would be great if we could run SQLite tests right now whenever people run tests. It would be great if people could set up pgsql to automatically run too, but that would require manual setup. This is the kind of thing automated tests are really helpful for. (But that's kind of tangential.)