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-
views:
42answers:
1
+4
A:
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.
Confluence
2010-09-30 17:26:47
Agreed. SQLite is *awesome* for low-concurrency, but it simply doesn't provide the find-grained locking that more heavyweight DBs (Postgres, MySQL, etc) can provide, so high concurrency gets very tricky.
David Wolever
2010-09-30 17:59:01
thanks! I may need to look into MySQL and see if they have a cloud ready version
aron
2010-10-01 15:08:51