[sqlalchemy] Database locking

2010-04-26 Thread gazza
Hello,

I am using multiple servers to access a sqlite db via sqlachemy. I am
using the latest SQLAlchemy and pysqlite-2.6.0.

I get permenant locking and it causes mayhem. I did rebuild sqlite to
make it --enable-threadsafe.

Whats the approach to handle this problem?

Thanks,
garyc

-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



Re: [sqlalchemy] Database locking

2010-04-26 Thread Michael Bayer
gazza wrote:
 Hello,

 I am using multiple servers to access a sqlite db via sqlachemy. I am
 using the latest SQLAlchemy and pysqlite-2.6.0.

 I get permenant locking and it causes mayhem. I did rebuild sqlite to
 make it --enable-threadsafe.

 Whats the approach to handle this problem?

one helpful thing is to disable connection pooling.   see
http://www.sqlalchemy.org/docs/reference/dialects/sqlite.html#threading-behavior
.


 Thanks,
 garyc

 --
 You received this message because you are subscribed to the Google Groups
 sqlalchemy group.
 To post to this group, send email to sqlalch...@googlegroups.com.
 To unsubscribe from this group, send email to
 sqlalchemy+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/sqlalchemy?hl=en.



-- 
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.