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.