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?
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.
.
.