SQLite databases timing out

Scripting Forums AppleScript | Mac OS X
#1

I seem to recall reading somewhere (though I can’t find it now) that the system will close an open SQLite database after 5 minutes to save memory. I am running into some problems while trying to process large amounts of data getting “connection lost” errors to the database so I am guessing that I might be running into this problem.

My question is: Is there a way to extend the default length of time a database may remain open? If so, would you be so kind as to share?

Thanks.

#2

Have you checked the archives at the SQLite Users site?

#3

It doesn’t LOOK like a webpage I have seen before… I’ll check it out, thanks.

#4

It is one of those mailing list Q & A setups and very, very useful, regardless of the platform. If there is nothing in the archives, be sure to post your question there, and the responses are fast and typically accurate.