The big warning on this page seems a bit unfounded, especially the claims that sqlite is designed for one process at a time and that reads (SELECT) create locks.
Can multiple applications or multiple instances of the same application access a single database file at the same time?
Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however. JackieRipper 01:26, 3 September 2009 (UTC)JackieRipper