Re: [sqlite] Can SELECT queries lock the database for writing?

2005-02-24 Thread Kurt Welgehausen
I'm not sure I understand exactly what's in your table; there are no integrity constraints, so it's hard to infer anything. I added a row to cover a case you didn't mention; maybe you think it can never happen, but there's nothing in your schema that prevents it. select * from history order by lic

[sqlite] Can SELECT queries lock the database for writing?

2005-02-23 Thread George Ionescu
Hello dear SQLite users, Hello Dr. Hipp, while using a quite complex query with sqlite, which takes a lot of time to execute, I have found that it locks the database (e.g. any other process trying to write to the database gets SQLITE_BUSY). Is this the expected behavior? I have understood that