SQLAlchemy+pymysql Error: Sqlalchemy.util.queue.Empty

Trying to run Python3.2, SQLAlchemy0.8 and MySQL5.2 on Ubuntu using Eclispse but I keep getting the error below. Am using pymysql (pymysql3 actually) engine. module monitor from sq

Solution 1:

mysql-connector-python and oursql work fine for me under py3k.

How to install?

$ pip install mysql-connector-python

Usage

Engine = create_engine('mysql+mysqlconnector://<USERNAME>:<PASSWD>@<HOSTNAME>:<PORT>/<DBNAME>')

Solution 2:

Stay on py2k or a different DB driver for the time being. This is a known SQLAlchemy bug: 2663.