Does anyone know of a asynchronous mysql lib for python?

Question

I've been looking into non-blocking servers for python (tornado, twisted etc) but a lot of the benefits seems to be lost if there's no non-blocking connection to the database. Does anyone know if there are any projects that take care of this? (by non-blocking a la node.js)

Edit: Clarified my question

Answer 1

This may be stupid but isn't async troublesome in general (in python) due the the global interpreter lock?

Answer 2

The way you do that is by spawning database queries in a separate thread. With Twisted you can use deferToThread() or deferToThreadPool() (see the API docs[1]).

Answer 3

You can use Twisted's ADBAPI to wrap a synchronous DBAPI implementation.

E.g.:

from twisted.internet import reactor
from twisted.enterprise import adbapi

def result(rows):
    for row in rows:
        print row

    reactor.stop()

def fail(err):
    err.printDetailedTraceback()
    reactor.stop()

pool = adbapi.ConnectionPool('sqlite3', 'animals.db')
d = pool.runQuery('SELECT * FROM animals', ())
d.addCallbacks(result, fail)
reactor.run()