We're using it in production, both their cloud-hosted offering and for our on-prem software products. Massive scale isn't really a requirement for us but the multi-model capabilities are a winner for our use cases - being able to mix graph and relational-style queries in the same query language.
A problem for us is the Enterprise licensing is implemented such that our on-prem customers would have to manually update a license string once a year, which is a PITA and why we have previously been using Community edition despite paying for Enterprise (mostly for the support contract).
As a maintainer of the C#/.NET driver, I'd say our project isn't so much dead as it is complete. We use it in our products and if it requires updates due to breaking changes, we will maintain it, but otherwise it does what we need it to.
Also worth noting that ArangoDB did have one of their own developers work on the project and made many contributions.
Overtime CouchDB has been removing more and more functionality and features that made CouchDB great IMHO (e.g couchapps), the 2.x (IIRC) made a lot of changes and totally broke a large application and made it too challenging to update so we stayed on a 1.x version (whatever version was last before the big couch merge.) we're moving off of Couch entirely in the future.
I'd have a look at Couchbase if you're looking for replication features too.
Well, I've read about couchdb every few years, and people in the last ~5 years were complaining about an awkward query syntax, slow embedded JS engine (IIRC), client-side complexity of the document data model and effort to maintain.
Similar things could probably be said about mongodb. If your data is small enough, it probably doesn't matter.
Thanks, we're not dealing with very large data sizes: maybe up to 100K documents, maybe using large binary attachments up to 100s MB per attachment. We use another DB product (ArangoDB) as our main application DB, so would be using something like CouchDB only for the offline-first and peer-to-peer replication capability - then referencing items in CouchDB from our main application DB, where we're more than happy about query language and other features. I had a somewhat wild idea that someone (maybe us...) could implement the couch DB replication protocol for ArangoDB using the ArangoDB FOXX framework. Not sure how feasible that might turn out to be though, wonder if anyone else thought of it...
We have a pwa with pouchdb sync thousands handphones from couchdb every morning. Couchdb sync is great and pouchdb take care the db of whatever browser in your user phone.
I could say we pick couchdb just because of their sync and pouchdb. For our main db we use postgres.
A problem for us is the Enterprise licensing is implemented such that our on-prem customers would have to manually update a license string once a year, which is a PITA and why we have previously been using Community edition despite paying for Enterprise (mostly for the support contract).