On 03.09.2010, 23:19 Aryeh wrote:
SQLite currently uses the same schema as MySQL
Minus updates, which may be incompatible, and which people forget to add when they're adding updates to MySQL.
[...] 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.
I've been playing with automatic tests that verify the SQLite schema (proper conversion from MySQL, etc) and upgrades. These tests take advantage of SQLite's memory tables and therefore run conveniently fast to include them into standard unit tests. They also depend only on SQLite support and don't require any particular $wgDBtype. Of course, doing the same for other backends would be much harder. Will finish this work once my IRL deadline will be dealt with.
...By the way, upgrade tests grumble something about categories;)