1.4.9.1 MySQL

The MySQL implementation doesn't really have any complicaitons. It works extremely well and is the most tested implementation of the web.database specification.

One point to note is that is doesn't use a ColTypes table in the same way the other implementations do because the cursor.description contains all the information needed by the web.database module so there is no need to store it in an extra table. The other implementaions do not give adequate information in the cursor.description.

The MySQL implemenation is the only one to support the alter() method.

Warning: The MySQLdb module on which the MySQL driver is based automatically commits any changes you have made to the database when the script exits, regardless of whether you have explicitly committed the changes in the code. This is different to the behaviour of the other databases and may catch you out so please be aware it is going on. (If anyone knows how to fix this please, please let the authour know!)

See About this document... for information on suggesting changes.