> As long as no prepared statements are outstanding, you should > be safe moving sqlite database connections across threads, as > of version 3.3.1. The rules are not really quite that strict, > but the exact rules are more complex and this strict rule > gives you an extra margin of safety.
Is it possible to finalize statements in a separate thread? This would be a rather important feature because on most multi-threaded VMs, user-defined finalizers (which would be used to clean up SQLite objects which are no longer used) run in a separate thread.