I am wondering how SQLite implements it. Is it based on file locking? Of course, the entire database is not locked for each user who accesses it; that would be extremely inefficient. Is it based on multiple files or just one large file?
It would be nice if someone could give a brief overview of how synchronization and locking are done in sqlite or, of course, provide a link to one.
source
share