Re: [sqlite] checking the database status

[Dennis Jenkins]

Robert Simpson wrote:

um ... It's a file.  You just check to see if the file exists.  No 
sqlite calls involved.

Robert

That would work in this situation, but what about the inverse?  You only 
want to open the file IF it already exists.

There is a race condition: where you check for the file, don't find it, 
and then try to open the database, and in the mean time, a different 
process/thread has done the same?

I do not need this yes, but I can imagine situations where an atomic 
"create new database ONLY" would be very nice.