On Wed, Apr 22, 2015 at 2:58 PM, Graham Holden <SQLite at aldurslair.com> wrote:
> > > ?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. > ?You're right, that was in the original posting. I either missed that one sentence, or forgot it in the interim. Unfortunately, it does not appear that the question can be answered without some more information (which may be restricted). He did say that only his app has access to this directory, so there are no worries about "somebody else" putting files in it. So I am _guessing_ that there are files in that directory which need to persist between executions of his application. Now, if the OP can verify that only one instance of his app can run at a time (which means only that execution instance can create/update/delete files in the directory while that instance is running), then perhaps it would be possible for the app to keep a list of all file names in the given directory which exist before he starts up the SQLite portion of the application. Then, after he closes out the SQLite portion of the application, he again scans the directory again and deletes all files in the directory which did not exist at the time of the initial scan. This might work in a single threaded, single use at a time, type application. It would not work if multiple copies/instances of the app can run concurrently (hopefully using different SQLite data bases).? > > 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. > > -- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
