Re: [python-sybase] Executing SQL asynchronously

[Skip M. <sk...@po...>]

    >> I need to perform inserts and updates to a Sybase database
    >> asynchronously.  Is there already a mechanism in sybase-python to do
    >> this?  I see the Sybase module uses threads extensively.

    Dave> I suppose the best way to do this would be to perform the SQL
    Dave> operations in one or more separate Python threads.

That's pretty much what I came up with.  My initial tests at the command
prompt led me to believe that maybe I'd done something wrong, but I think I
was fine.  An AsyncConnection class has its own hidden cursor and a Queue.
The client gets a fake cursor that does nothing more than stuff the (sql,
params) tuple into the queue where it's picked up and executed by the real
cursor running in a daemon thread.

Skip