Sam Carleton <[email protected]> wrote: >> Will SQLite return errors on a regular basis >> if one thread or process tries to access the database when another >> thread/process already has a lock or will it handle such a situation >> normally and only in extreme cases do I need to worry about it
See sqlite3_busy_handler, sqlite3_busy_timeout >> I know I need to look for errors and fail gracefully, I am trying to >> figure out to what degree do I need to go? If there is an error, is >> it going to be a serious error where it needs to bubble to the user >> or is it a minor thing the code should try to fix first? This rather depends on the error, doesn't it? If you get SQLITE_BUSY, you could retry later and hopefully the problem will go away. If you get, say, SQLITE_IOERR, it's unlikely that retrying would help (your hard drive is failing). If you get SQLITE_MISUSE, there's a bug in your application. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
