How to increase connection timeout using sqlalchemy with sqlite in python

python sqlite sqlalchemy operationalerror
user1817188 picture user1817188 · Feb 25, 2013 · Viewed 9k times · Source

I am using sqlite (v2.6.0) as database backend and using sqlalchemy(v0.7.9) to operate it. Recently I got a error OperationalError: (OperationalError) database is locked

By searching stackoverflow a possible solution is to increase the timeout of a connection. Referece: OperationalError: database is locked

But I don't know how to did that in sqlalchemy (since connection are actually controlled by it) Can someone give me a direction?

Answer

Audrius Kažukauskas picture Audrius Kažukauskas · Feb 25, 2013

SQLAlchemy's create_engine() takes an argument connect_args which is a dictionary that will be passed to connect() of the underlying DBAPI (see Custom DBAPI connect() arguments). sqlite3.connect() accepts timeout argument, so this should work:

create_engine('sqlite:///some.db', connect_args={'timeout': 15})

Related questions

How to delete a table in SQLAlchemy?

I want to delete a table using SQLAlchemy. Since I am testing over and over again, I want to delete the table my_users so that I can start from scratch every single time. So far I am using SQLAlchemy …

Read More
Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?

Why is this simple test case inserting 100,000 rows 25 times slower with SQLAlchemy than it is using the sqlite3 driver directly? I have seen similar slowdowns in real-world applications. Am I doing something wrong? #!/usr/bin/env python # Why is SQLAlchemy …

Read More
How to discover table properties from SQLAlchemy mapped object

I have a class mapped with a table, in my case in a declarative way, and I want to "discover" table properties, columns, names, relations, from this class: engine = create_engine('sqlite:///' + databasePath, echo=True) # setting up root class …

Read More