[sqlite] long filenames on Mac OS

[Will Leshner]

My guess is that very few people care about this problem, but on the 
"Classic" versions of Mac OS (basically 8 and 9), you can't have file 
names longer than 31 characters. This becomes a problem when you have a 
database file name that is very long, but not longer than 31 
characters. When you try to update such a database file, SQLite needs 
to create a journal file and it does that by creating a new file with 
the name of the database file plus "-journal", which can end up 
exceeding the 31 character limit. In that case, the journal file fails 
to be created and the entire update procedure fails as well. I don't 
know what the solution to this is. One idea I had was to conditionally 
shorten the journal file's suffix to simply "-j". That doesn't really 
solve the problem, but it might make things a little better. Would such 
a change be dangerous? Is there some chance that this would interact 
badly with another version of SQLite that hadn't made such a change?

Thanks for any advice.

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