Thanks Pete. I'm definitely interested in using PyMySQL for production.
I'm interested in running Django in an async mode using gevent (http:// www.gevent.org/). gevent provides a money patch that turns any Python code into non-blocking. The problem is that MySQLdb is written in C, so it'd still block, which would kinda defeat the whole purpose of having an async Django app if every database access is blocking. PyMySQL looks like could be a great solution for this problem. In fact there's already a thread in the gevent mailing list talking about PyMySQL. You might want to drop by: http://groups.google.com/group/gevent/browse_thread/thread/b5f7bf44b7690ed9 On Sep 4, 4:58 pm, Pete Hunt <floydoph...@gmail.com> wrote: > Hi Andy - > > Below is a patch that will let Django use pymysql if MySQLdb is not > available. Currently it is not in use in production anywhere but I am > hoping to change that soon. Currently its primary use is prototyping > applications that are being developed on Mac OSX but deployed on > Linux. If you are interested in using it in production please let me > know and I will be sure to prioritize any tickets related to > production issues. > > Simply search-replacing MySQLdb with pymysql in django/db/backends/ > mysql/base.py and django/db/backends/mysql/introspection.py will get > it to work. I will submit a patch soon that tries to import MySQLdb > but falls back to pymysql if it is not available. > > Pete > > On Sep 3, 5:20 pm, Andy <selforgani...@gmail.com> wrote: > > > > > Pete, > > > Would you recommend PyMySQL for production use? > > > Which parts of Django do I need to modify in order to use it with > > PyMySQL instead of MySQLdb? > > > Thanks. > > > On Sep 3, 2:07 pm, Pete Hunt <floydoph...@gmail.com> wrote:> I’m proud to > > announce the release of PyMySQL 0.3. For those of you > > > unfamiliar with PyMySQL, it is a pure-Python drop-in replacement for > > > MySQLdb with an emphasis on compatibility with MySQLdb and for various > > > Python implementations. I started working on the project due to my > > > frustrations stemming from getting MySQLdb working on Snow Leopard. > > > PyMySQL has been tested on CPython 2.3+, Jython, IronPython and PyPy, > > > and we have an unreleased Python 3.0 branch in Subversion. I encourage > > > anyone hoping to connect to MySQL from Python to check it out and > > > report any bugs you might find! Our current focus has been bringing it > > > up to compatibility with SQLAlchemy and Django, and we have by and > > > large achieved that goal with a high level of performance. > > > > This is of specific interest to Django users, as one can simply > > > replace references to "MySQLdb" with "pymysql" and run their Django > > > apps on platforms that are difficult to get working with MySQLdb (like > > > Mac OSX Snow Leopard). > > > > Check it out athttp://www.pymysql.org/. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
