CODEWITHSUNDEEP
pythonsqlite
Stephen Gross
Stephen Gross

Reputation: 5724

How to lock a sqlite3 database in Python?

Is there a way to explicitly acquire a lock on a sqlite3 database in Python?

Upvotes: 9

Views: 16460

Answers (3)

Nagesh HS
Nagesh HS

Reputation: 95

We can use multiprocessing commands to lock the DB write and read process. I am using the following commands and it's working fine:

from multiprocessing import Lock 
l.Lock()
l.acquire()
# Read/Write DB 
l.release()

Upvotes: 1

unutbu
unutbu

Reputation: 880637

From the sqlite FAQ, "Can multiple applications or multiple instances of the same application access a single database file at the same time?":

Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however.

Whether or not you use the with connection construct, many processes can read from by only one can write to the database at any given time.

Upvotes: 5

jcollado
jcollado

Reputation: 40414

The way to explicitly lock the database is start a transaction as explained in the documentation:

When a database is accessed by multiple connections, and one of the processes modifies the database, the SQLite database is locked until that transaction is committed.

One way to initiate a transaction is use the connection as a context manager:

import sqlite3
con = sqlite3.connect(...)
...
with con:
    # Database is locked here

Also note that some transactions happen implictly by default:

By default, the sqlite3 module opens transactions implicitly before a Data Modification Language (DML) statement (i.e. INSERT/UPDATE/DELETE/REPLACE), and commits transactions implicitly before a non-DML, non-query statement (i. e. anything other than SELECT or the aforementioned).

Upvotes: 11

Related Questions