Multiple connections can be taken to SQLite. However, when modifications are made, only a single transaction can modify the data at any time. So if you're planning to have a high amount of concurrent modifications, I don't believe that SQLite will scale very well.
More info, see:
http://www.sqlite.org/faq.html#q5[
^]