Can I use the SQLite as a db storage for cloud-bas

问题:

Has anyone ever launched cloud-based apps / websites that use a local SQLite DB as the primary data source?

Are there any warnings about this?

My environment:

• C# 3.0 app
• currently uses a sql server 2008 db
• current db size 30 mb-

回答1:

If you expect a lot of traffic, you really shouldn't. SQLite is meant to be used as a lightweight SQL database, and is not meant for highly concurrent access (since it locks the whole database file) which could be an important requirement in this case.

Read: Appropriate uses for SQLite