sqlite and processes

[Rick Pritchett]

I have one very important question.  I understand that sqlite uses locks when a process is writing to it.  Meaning that only one process can write to the databse but many can read.  What would happen if i had more than one thread in the same process try to write the the database at the same time?

Topic

[Charlie Bursell]

Simply setup a retry.  The lock is usually in the order of milliseconds

[Max Drown (Infor)]

Rickey, I *think* that the process only locks the db table on an insert/update type of event. So basically, multiple processes would have to just wait their turn which to our senses would be nearly instant.

-- Max Drown (Infor)

[Rick Pritchett]

I found the timeout command on the sqlite web site.

[Author]

Replies