On Fri, Sep 3, 2010 at 3:41 PM, Max Semenik
<maxsem.wiki(a)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:
MSSQL only runs on Windows, which is a nuisance for many of us, but
still feasible for pre-release testing.
-- Tim Starling