On 04/09/10 06:10, Aryeh Gregor wrote:
On Fri, Sep 3, 2010 at 3:41 PM, Max Semenik maxsem.wiki@gmail.com wrote:
...By the way, upgrade tests grumble something about categories;)
You can't expect anyone to write upgrades for database backends they've never used before, let alone ones like Oracle or MSSQL that they might not even have access to. The only sane thing is to have an abstraction layer. Once we have that, there's no reason in principle that support for non-MySQL backends should ever have to break, so we can talk about running real non-MySQL sites off trunk, or running tests for all databases on every checkin. That would be a really nice step forward -- I imagine trunk is unusable for non-MySQL users as a general rule.
It would be great if the maintainers of the less-commonly used DBMSes could write up development guides and put them in phase3/docs. These guides could describe relevant differences in SQL syntax compared to MySQL, and explain how to write schema files.
MSSQL, DB2 and Informix all have free (as in beer) versions available for download that we could use for testing:
http://www.microsoft.com/sqlserver/2005/en/us/express.aspx http://www-01.ibm.com/software/data/db2/express/ http://www-01.ibm.com/software/data/informix/developer-edition/
MSSQL only runs on Windows, which is a nuisance for many of us, but still feasible for pre-release testing.
-- Tim Starling