On 25 Aug 2011, at 4:32pm, François wrote: > 1) Do you suggest to open only one connection for all database > requests in the application, and to close it when user exits from the > application (scenario A) ? Or to use one connection for each > transaction (scenario B) ?
One connection for all transactions should be fine. Unless your application needs database access while it's in the background, the connection should be closed when the application is shifted to the background or, of course, quit. Open the connection again either when the app is foregrounded, or the first time you need SQLite access and haven't opened the connection yet. > 2) If scenario A, how to be sure that database is properly closed when > user exits ? I mean, using applicationWillTerminate and > applicationWillResignActive methods helps but this is not sufficient > because there are other cases where user exists. For example, if he > kills himself the app or if it crashes. If the user kills the app properly, using the app row, the app should still receive applicationWillTerminate. I think the only situation when it does not receive this is when the operating system decides the app has stopped responding to events -- like the 'Force Quit' situation for OS X. In which case, we are dealing with a crash, so let's consider that part of the question. I have checked the operation of SQLite on iOS under crashing situations and it seems to correctly deal with this situation, recovering data from journal files and restoring to an uncorrupted state, just as it does on other platforms. My testing was with a simple database and normal transactions so I didn't try many complicated or unusual situations, but everything I tried worked as expected. There are some aspects of operation under iOS 5 I can't comment on here, but there will be no real problems if you follow Apple's guidelines for startup and shutdown of iOS apps. I will also be interested in answers from other programmers. Writing apps for the iPhone isn't like normal programming ! Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
