SQLite Forum

Opening a DB with SQLITE_OPEN_EXCLUSIVE
Login
What problem are you trying to avoid by adding O_EXCL to open() calls?
Why do you need to ensure that no other process
is jumping in and creating the database file ahead of you?

Suppose your application is doing this:

   1.  Check to see if the SQLite database already exists
   2.  If it does not exist, create it.

What harm would come about if another rogue process created the
database in between steps 1 and 2?  I can invent a contrived scenario
where that might lead to trouble, but I'm having trouble coming up
with a real-world use case where that might be harmful.  Presumably you
have such a use-case.  Can you share it with us?