[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.



[sqlalchemy] Re: Database locking

2010-04-26 Thread gazza
Thanks Michael. Not sure if this is the only thing I need to do. Why
disable connection pooling?

Thanks,
Garyc


On Apr 26, 10:32 am, Michael Bayer mike...@zzzcomputing.com wrote:
 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.   
 seehttp://www.sqlalchemy.org/docs/reference/dialects/sqlite.html#threadi...
 .



  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 
 athttp://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.