Please do not use SQLite for multiuser systems. You will have a bad time.
Better databases have row level locking which allows many users to update the same table at the same time.
- And this isn't all that strange, say you wanted to store a timestamp for the last time a user visited your site, session ids, etc.
UPD: Good explanation http://sqlite.org/whentouse.html
Nitpick: Databases that make different tradeoffs have row level locking. SQlite is very good, for the niche that it's in, which is a lightweight, embeddable database for primarily single-user applications. It's incredibly popular in that space, to the point of likely being the most-used database on the planet by number of running instances since it's in so many smartphones/embedded devices.