> ?Well, the best that I can think of is to have your application create a > new, randomly named, directory...
I can't help directly (I don't the innards of SQLite) but can hopefully clarify what *I* think Simon's asking: he's already said in his original message that he used to use a temporary directory, but now cannot do this. Neither is he asking about how to encrypt files, nor how to securely delete them. He just wants to know which files SQLite *might* create that he needs to be concerned about deleting on exit. Sorry for the rant, but there's been a lot of probably well-meaning responses that don't seem to have read Simon's questions. Graham.