I suggest an alternate solution for this problem which should be more 
elegant, and is already used by Apple when copying dual-fork files to a 
single-fork file system.

What you could do is create a subdirectory within the directory having the 
SQLite "main" data file that has a constant name (probably determined in 
os.h) like ".SQLite-journal".  The journal file would then go into this 
subdirectory and have the same name as the main file.  So we have:

Normal way:
1 - ./mydatafile
2 - ./mydatafile-journal

Altered way:
1 - ./mydatafile
2 - ./.SQLite-journal/mydatafile

This solution would also work on file systems that are limited to 255 
character names, or 8 character names, or whatever.  The old Mac OS isn't 
the only one with a limit.

Also, if future versions of SQLite wanted to add more temp files, they 
could add a new directory for each on less capable systems, as they would 
add a new suffix on more capable ones.

-- Darren Duncan


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to