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

2019-06-07 01:43发布

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-

标签: sqlite cloud
1条回答
放我归山
2楼-- · 2019-06-07 01:54

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

查看更多
登录 后发表回答