Sunanda Menon MySQL Connector/Python 1.1.1-alpha has been released
Sep 10, 2013; 17:27
Sunanda Menon
MySQL Connector/Python 1.1.1-alpha has been released
Dear MySQL users,
MySQL Connector/Python 1.1.1 is the next alpha version of the 1.1 release series of the pure Python database driver for MySQL. It is intended to introduce users to the new features.
This release is not feature complete but it should be stable enough for users to understand the new features and how we expect them to work.
As is the case with all non-GA releases, it should not be used in any production environment.
MySQL Connector/Python version 1.1.1-alpha is compatible with MySQL Server versions 5.5 and greater, but should work with earlier versions (greater than 4.1). Python 2.6 and 2.7, as well as Python 3.1 and greater are supported.
MySQL Connector/Python 1.1.1-alpha is available for download from
The ChangeLog file included in the distribution contains a brief summary of changes in MySQL Connector/Python 1.1.1. For a more complete list of changes, see below or online at:
Changes in MySQL Connector/Python 1.1.1 (2013-09-10, Alpha) --------------------------------------------------------------------------------------
Functionality Added or Changed
* Output for individual unit tests did not show timings, making it more difficult to debug problems that involve a change in test execution time. unittest.py now has a new --stats option that runs tests and shows elapsed time for each. It is also possible to save the data to a MySQL server. When the --stats-host option is given with other options such as --stats-user, results are saved to a table called myconnpy_X_Y_Z. The table contains the name of the test case and columns that combine Python and MySQL versions; for example, py27my55 or py33my56. For example, to see the difference between MySQL 5.1 and 5.6, using Python 2.7, after running the test cases for both using Connector/Python 1.1.0, use this statement: SELECT test_case, py27my51, py27my56, (py27my56-py27my51) AS diff51 FROM myconnpy_1_1_0 WHERE (py27my56-py27my51) > 0.5; (Bug #17028999)
* MySQL Connector/Python now supports simple connection pooling that has these characteristics:
+ A pool opens a number of connections and handles thread safety when providing connections to requesters.
+ The size of a connection pool is configurable at pool creation time. It cannot be resized thereafter.
+ A connection pool can be named at pool creation time. If no name is given, one is generated using the connection parameters.
+ The connection pool name can be retrieved from the connection pool or connections obtained from it.
+ It is possible to have multiple connection pools. This enables applications to support pools of connections to different MySQL servers, for example.
+ For each connection request, the pool provides the next available connection. No round-robin or other scheduling algorithm is used.
+ It is possible to reconfigure the connection parameters used by a pool. These apply to connections obtained from the pool thereafter. Reconfiguring individual connections obtained from the pool by calling the connection config() method is not supported. Applications that can benefit from connection-pooling capability include:
+ Middleware that maintains multiple connections to multiple MySQL servers and requires connections to be readily available.
+ Web sites that can have more "permanent" connections open to the MySQL server.
The connection pooling implementation involves these interface elements:
+ A new module, mysql.connector.pooling, provides two classes: MySQLConnectionPool instantiates and manages connection pools, and PooledMySQLConnection is similar to MySQLConnection but is used for connections that are part of a connection pool.
+ A new exception, PoolError, occurs for pool-related exceptions. PoolError is a subclass of Error. For more information, see Connector/Python Connection Pooling
* Connector/Python now includes a mysql.connector.django module that provides a Django backend for MySQL. This backend supports new features found in MySQL 5.6 such as fractional seconds support for temporal data types. For more information, see Connector/Python Django Backend
* Following fetchone() or fetchmany(), the result returned by fetchall() was missing one row. (Bug #17041412)
* Previously, executing a statement after the connection was closed raised an OperationalError with an unclear error. Connector/Python now returns the client error 2006, MySQL Server has gone away, with an extra message. The Error() class has been extended to accept a new argument, extra_msg. When given, it is appended between brackets. For example: [2000] Unknown MySQL Error (Some extra message) (Bug #17022399)
* LOAD DATA LOCAL INFILE failed for files approximately 14MB or larger. (Bug #17002411)
* An InternalError was raised during transaction rollback if there were unread results. The MySQLConnection.rollback() method now consumes unread results instead of raising an error. (Bug #16656621)
* Python 2.6 and 2.7 raised a UnicodeDecodeError when unicode_literals was used and a database name contained nonlatin Unicode characters. (Bug #16655208)
* An unclear OperationalError was raised if a cursor object was closed while there were unread results. Connector/Python now raises an InternalError indicating that there are still unread results. This provides information that to avoid the error it is necessary to consume the result by reading all rows. (Bug #67649, Bug #17041240)
* The MySQLCursor.executemany() method raised an exception when a SQL function was used as a column value when executing an INSERT statement. (Bug #69675, Bug #17065366)
The source distribution includes the manual in various formats under the docs/ folder.
Reporting Bugs --------------------
We welcome and appreciate your feedback and bug reports: http://bugs.mysql.com/
Enjoy!
On Behalf of the MySQL RE team at Oracle,
Sunanda Menon
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!