sqlite - Is CouchDb suitable for use on client desktops (Windows 10)?

Question

I want to support the users of my Windows 10 desktop application with:

1. Local Data (not having to perform a fetch from the cloud every time they want new data)
2. Offline support
3. Replication with a cloud database

There can potentially be multiple users (in the order of 10-100 but not 1000) simultaneously editing the same database. I would run CouchDb as a service (ie. in a separate process to my app).

To achieve the above I am considering installing CouchDb on each client desktop PC (all replicating to a single main cloud CouchDb instance) together with my application to achieve the above goals.

One of the reasons I am pursuing this line of thinking is that it would allow my application code to mostly just be written in a manner that interacts with local data and the sync/replication (which is probably quite complex) can be taken care of by CouchDb.

I am using CouchDb as a replacement for something that I often see is done by sqlite but I really want the replication ability of CouchDb (which sqlite does not have).

Is the above a scenario in which I can expect CouchDb to perform well or is there something that I am not considering?

标签： sqlitecouchdb

Answer 1

We have multiple clients doing this successfully. This is a recommended use-case for CouchDB. The limiting factor will be the cloud vm configuration, but 100s to 1000s of clients should be no problem on a decent vm setup.