CODEWITHSUNDEEP
sqlite
arcee123
arcee123

Reputation: 211

SQLite multiple queries in parallel

I have a SQLite3 database file, and I realize when attempting to write or read from it, it opens and locks the db file. Is there any way to avoid the lock so a second script can access it as well?

In other words, how do I perform a NOLOCK on a SQLite3 database file?

Upvotes: 1

Views: 1463

Answers (1)

CL.
CL.

Reputation: 180020

That is not how SQLite's locking works. Multiple connections can read from the DB at the same time. And with WAL mode, readers are not blocked by a writer.

Upvotes: 2

Related Questions